Postby mszczesn » Fri 15 Sep 2006 09:59

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 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
Posts: 2
Joined: Wed 06 Sep 2006 13:30

Postby Challenger » Fri 15 Sep 2006 13:13

No, Delphi TIMESTAMP, SQLTIMESTAMP data types are not able to store information about time zone.
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Return to dbExpress driver for Oracle