Archives of the TeradataForum

Message Posted: Thu, 10 Oct 2002 @ 20:21:06 GMT

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

This works for me

select date - ('20020101' (date, format 'YYYYMMDD') )

it returned 285.

whereas (date - '2002-01-01') returned -18999091.00000

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