Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

Dates are wrong in the browser - off by one day

Using Oracle SQL Developer, the EMPLOYEE table returns accurate birthdate as 18-FEB-62. In the Oracle Mobile Database Client app on iPad, that value is showing as 2/17/62.

This is off by 1 day. This occurs in both a HIREDATE field and BIRTHDATE field.

Database is on linux... Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production.

BIRTHDATE and HIREDATE are datatype = DATE.

SQL*PLUS returns:

SQL> select BIRTHDATE,HIREDATE from EMPLOYEE;

BIRTHDATE HIREDATE
------------------ ------------------
18-FEB-62 14-AUG-02
08-DEC-58 01-MAY-02
29-AUG-73 01-APR-02
19-SEP-47 03-MAY-03
03-MAR-65 17-OCT-03
01-JUL-73 17-OCT-03
29-MAY-70 02-JAN-04
09-JAN-68 04-MAR-04

2 people have
this problem
+1
Reply