Archives of the TeradataForum

Message Posted: Fri, 31 Dec 2010 @ 12:22:31 GMT

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

Maria,

Expression DATE+0 is converting date data type to integer and then performing comparison. You can check the difference by executing below query on your SQL assistant.

     Sel date(integer),date+0;

The output is 1,101,231 and 12/31/2010

Cheers!!!

Deepak

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