Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


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?



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020