Archives of the TeradataForum
Message Posted: Thu, 05 Aug 2010 @ 18:16:00 GMT
I ran below SQL to extract all rows that have a timestamp newer than one week ago but got an error code 5407. How should I change this SQL?
SELECT * FROM DBC.Logonrules WHERE Date - CreateTimeStamp < 7 ORDER BY CreateTimeStamp DESC;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|