Archives of the TeradataForum

Message Posted: Tue, 14 Nov 2006 @ 14:23:38 GMT

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

Try this syntax:

     SELECT CURRENT_TIMESTAMP (FORMAT'HH:MI:SS');

Or

     SELECT CAST((CURRENT_TIMESTAMP (FORMAT'HH:MI:SS')) AS CHAR(8));

Joseph M. Martinez
Business Data Management

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