Archives of the TeradataForum

Message Posted: Wed, 29 Feb 2012 @ 16:05:01 GMT

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

Hi,

Maybe this will work (works in Sql Assistant):

     SELECT
     CAST(CAST(CURRENT_DATE AS FORMAT 'yyyy-mm-dd') AS char(10))
      || ' ' || CAST(CAST(CURRENT_TIME AS FORMAT 'HH:MI:SS') AS CHAR(8)) ;

Pozdrawiam,
Aneta Ruszczyk

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