Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 13:19:36 GMT

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

If you are doing this in SQLA, you always get system default format for date. SQLA does not handle format very well. Try running in bteq mode.

     select cast(current_timestamp as date FORMAT 'YYYYMMDD');

Kevin

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