All Forums Database
janus 4 posts Joined 06/09
12 Feb 2010
Extraction of time from timestamp!

From the TD user manual, i got this as an example of timestamp to time conversion:

SELECT CAST(cast('1997-12-31 23:59:59' as timestamp(5)) AS TIME(5) WITH TIME ZONE);

But why the time zone? how can I extract just the time with no timezone. I didn't define any timezones anywhere...

Any thoughts on this would be great

janus 4 posts Joined 06/09
12 Feb 2010

solved the problem - it was in sql assistant. the same query runs fine in bteq =))

You must sign in to leave a comment.