Extraction of time from timestamp!

Database
Teradata Employee

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

1 REPLY
Teradata Employee

Re: Extraction of time from timestamp!

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