What about TIMESTAMP WITH TIME ZONE?

mint

Member²
Since Oracle 9 there are new data types TIMESTAMP WITH [LOCAL] TIME ZONE. How are these supported with DOA? Apparently, D2006 supports them now. Otherwise, what would be the recommended way to handle time zones? I have lots and lots of DATE fields and have to add time zone support...
 
In a TOracleDataSet they are treated as dates, or strings if you set TOracleSession.Preferences.TimestampAsString to True. The TOracleQuery additional provides a TimeStampField funtion, returning a TOracleTimestamp instance.
 
Back
Top