Archives of the TeradataForum

Message Posted: Wed, 21 Nov 2007 @ 13:10:36 GMT

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

Have you tried:

     sel count(*) From    test
     Where   Exit_Date = '0001-01-01'

With your bogus dates, I am guessing it will return a value of 35725730-4=35725726

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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