Timestamp

Timestamp

Postby mszczesn » 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
mszczesn
 
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.
Challenger
Devart Team
 
Posts: 925
Joined: Thu 17 Nov 2005 10:53


Return to dbExpress driver for Oracle