Archives of the TeradataForum

Message Posted: Tue, 09 Nov 2010 @ 14:49:39 GMT

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

Try this.

     SELECT TO_CHAR (SYSTIMESTAMP, 'YYYY-MON-DD HH24:MI:SS'),'YYYY-MON-DD HH24:MI:SS') AS MY_DATE
       FROM DUAL

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