Archives of the TeradataForum

Message Posted: Fri, 27 Aug 2010 @ 15:58:23 GMT

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

You can also cast the result to a charter type field in sql assistant to get the format. Something like below

     SELECT cast((CURRENT_DATE (FORMAT 'Y4:M4:D3')) as char(20));

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA

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