JAVA to ORACLE Date Problems

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Guest1234
    New Member
    • Jun 2007
    • 3

    JAVA to ORACLE Date Problems

    Hello,
    I have a function in Java that stores the Date in Oracle Database,
    If i Try to store todays Date (19/06/2007) it takes well in Java Program but its stores 18/06/2007 in Oracle Database.
    My local TimeZone for Windows is Europe/Paris and is same for Oracle and Java.
    If i change the Windows TimeZone to US/Canada (Pacific Time) , It stores 19/06/2007.
    I dont understand how TimeZone of Windows is affecting in Oracle.
    Please help on it.

    I am using
    Oracle 10g
    Java 1.4
    Apache
    Tomcat on WindowsXP
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    can u please specify what is the data type u are using to store date

    is it date or u are using any other type like timestamp or any of its sub-types.

    and what is the format of date field.

    Comment

    • Guest1234
      New Member
      • Jun 2007
      • 3

      #3
      Originally posted by debasisdas
      can u please specify what is the data type u are using to store date

      is it date or u are using any other type like timestamp or any of its sub-types.

      and what is the format of date field.

      Hello,

      I am using Date format to store the Date.

      Comment

      Working...