Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2010 @ 21:27:00 GMT

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

You may need to cast the timestamp to date ..

This should work ..

     SELECT
     *
     FROM DBC.Logonrules
     WHERE Date - cast(CreateTimeStamp as date) < 7
     ORDER BY CreateTimeStamp DESC;

Regards

Jaydeep.

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