Skip to Content
0
Former Member
Mar 19, 2009 at 08:57 AM

Time Zone in Oracle

34 Views

Hi All,

We have a requirememt to to put date time with time zone information.

We are having ORACLE 9.2 and xMII 11.5.

When I am executing sql

INSERT INTO <tblname> (colName) values (TIMESTAMP , '2009-03-16 14:10:00') from toad,

its inserting with the correct time zone information as 16/03/2009 02:10:00.000000 PM +09:00

Same SQL from xMII inserts value as 16/03/2009 02:10:00.000000 PM +00:00

The colName datatype is TIMESTAMP(6) WITH TIME ZONE.

Please help oon this.

Rupesh