Archives of the TeradataForum

Message Posted: Tue, 29 May 2012 @ 16:22:55 GMT

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

Hi

Try the query given below in TeraData SQL Assistant.

Your system will answer you what is difference between DATE FORMAT 'YYDDD' and DATE FORMAT 'YYDD'.

     SELECT DATE(FORMAT'DDD')(CHAR(5)) AS DDD, DATE(FORMAT'DD')(CHAR(5)) AS DD

Regards,

Ravi

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