Timestamp
Posted: Fri 15 Sep 2006 09:59
Hi
Is the 'timestamp' type supported with dBExpress Net option? I perform such a test:
1. create table dss_temp ( time TIMESTAMP(3) WITH TIME ZONE );
2. insert into dss_temp values ( sysdate);
3. select * from dss_temp;
The result on Oracle Sql Plus interface is something like this:
15-SEP-06 11.15.42.000 AM +02:00 so it is 11 o'clock AM
However when I run this query in my Delphi application and read the field time into Tdatetime variable using dBexpress, instead of 11AM I get 9AM - the time zone information is lost. Is there any way to read the TIMESTAMP field correctly without converting it into string on the Oracle server?
Thanks for any help
Is the 'timestamp' type supported with dBExpress Net option? I perform such a test:
1. create table dss_temp ( time TIMESTAMP(3) WITH TIME ZONE );
2. insert into dss_temp values ( sysdate);
3. select * from dss_temp;
The result on Oracle Sql Plus interface is something like this:
15-SEP-06 11.15.42.000 AM +02:00 so it is 11 o'clock AM
However when I run this query in my Delphi application and read the field time into Tdatetime variable using dBexpress, instead of 11AM I get 9AM - the time zone information is lost. Is there any way to read the TIMESTAMP field correctly without converting it into string on the Oracle server?
Thanks for any help