Archives of the TeradataForum

Message Posted: Fri, 27 Aug 2010 @ 15:46:07 GMT

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

if you request DB thru ODBC, format phrase will not apply. ODBC will force the format with local regional setting.

If you want the format that you specified you need to cast your data into varchar

     SELECT CURRENT_DATE (FORMAT 'Y4:M4:D3') (varchar(50))

Regards.

PAtrick

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