Archives of the TeradataForum

Message Posted: Thu, 10 Oct 2002 @ 20:15:38 GMT

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

Rajech,

Your problem is the format of '2002-01-01'. Try this:

select (date - cast('2002-01-01' as date format 'yyyy-mm-dd'));

Hope this works for you.

Johannes

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