Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Posts: 2
Joined: Wed 06 Sep 2006 13:30


Post by 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

Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 15 Sep 2006 13:13

No, Delphi TIMESTAMP, SQLTIMESTAMP data types are not able to store information about time zone.

Post Reply