Archives of the TeradataForum

Message Posted: Thu, 19 Apr 2012 @ 10:37:46 GMT

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

<-- Anonymously Posted: Thursday, April 19, 2012 04:33 -->

Hi,

This is due to the way dates are stored internally. The below one will give you 2007-04-01.

     SELECT CAST(1070401 AS DATE FORMAT 'YYYY-MM-DD');

Regards

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