Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2012 @ 14:03:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I ran the same query on TD 13.0 on Windows and got an error saying, 'SELECT failed. 3707: Syntax error. expected something like a 'LOCAL' keyword between the 'AT' keyword and the string 'g' keyword.

     sel current_timestamp at 'gmt' (title 'GMT TIME'),
         current_timestamp at  'america pacific' (title 'America Pacific TIME'),
         current_timestamp at  'america eastern' (title 'America Eastern TIME');

I guess TD 13 doesn't support this query. Is there no way to find different time zones in 13.0?

	<Prev	Next>		<<First	<Prev	Next>	Last>>