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
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
Comment