Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 Dec 2002 @ 21:44:41 GMT

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

Subj:   Re: TIMESTAMP in Teradata
From:   Fred W Pluebell

In V2R5 you can apply your own format to time and timestamp. Otherwise, check the default formatting and adjust accordingly. For example, on V2R4.1.3 system

SELECT format(current_timestamp);

yyyy-mm-dd hh:mm:ss.s(6)-hh:mm

So the following would do the trick:

SELECT CAST ( ( SUBSTRING ( ( CAST ( Current_Timestamp AS CHAR(32) ) )
FROM 1 FOR 26 ) ) AS CHAR(26) );

  <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: 15 Jun 2023