Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Feb 2012 @ 16:49:44 GMT


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


Subj:   Re: To extract certain DATE-TIMESTAMP
 
From:   Clark, Dave

This should do it....

     SELECT
               CAST(CAST(CURRENT_timestamp AS FORMAT 'yyyy-mm-ddbHH:MI:SS') AS
     char(19))
                ;

     *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     Current TimeStamp(6)
     --------------------
     2012-02-29 18:34:51


     
  <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: 23 Jun 2019