Archives of the TeradataForum

Message Posted: Wed, 18 Apr 2012 @ 19:31:33 GMT

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

Add 1000000 to it...

     SELECT CAST(1000000 + 070401 AS DATE FORMAT 'YYYY-MM-DD')

Output is 2007-04-01

Thanks.

Dirk Anderson
SVP, Manager of Architecture & Strategy
Chief Data Officer Organization
Bank of America

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