Problems with Timestamp with Zone Oracle type
Posted: Tue 17 Sep 2013 21:53
Hi,
We are using Oracle type Timestamp with Zone in our database. Using UniDirectCommand and UniDirectDataAdapter we fill a dataset with columns for this type set as DateTime, Kind.LocalUnspecified. Unfortunately, the query returns the time exactly like in the database and drops the timezone (the application is windows based with class libraries). As a result dataset just decides that time zone is local which is actually wrong.
I tried to change data type Kind to UTC, it didn't change anything.
Then I tried to switch to DateTimeOffset and got casting types error.
So what is the best way to handle TimeStamp With Zone datatype with UniDirect controls?
Thank you,
Galina
We are using Oracle type Timestamp with Zone in our database. Using UniDirectCommand and UniDirectDataAdapter we fill a dataset with columns for this type set as DateTime, Kind.LocalUnspecified. Unfortunately, the query returns the time exactly like in the database and drops the timezone (the application is windows based with class libraries). As a result dataset just decides that time zone is local which is actually wrong.
I tried to change data type Kind to UTC, it didn't change anything.
Then I tried to switch to DateTimeOffset and got casting types error.
So what is the best way to handle TimeStamp With Zone datatype with UniDirect controls?
Thank you,
Galina