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