Archives of the TeradataForum

Message Posted: Mon, 17 Nov 2008 @ 20:44:42 GMT

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

<-- Anonymously Posted: Mon, 17 Nov 2008 15:20 -->

Especially if it's CHAR(10) anyway, just change your format to export 4 digit year. If you don't want to ALTER the table, then CAST(dateField as CHAR(10) FORMAT 'YYYY-MM-DD')

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