Archives of the TeradataForum

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

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

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>>