Archives of the TeradataForum
Message Posted: Tue, 21 Feb 2012 @ 14:03:09 GMT
| Subj: || || Re: Converting TIMEZONE data to Specific Region Time Value |
| From: || || JAMES PARK |
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?