RE: SQL date help

As an example, does this provide the correct records to delete ?
(untested): - 

select timestamp_iso(date(current timestamp -7 days)), filetimestamp
from file where filetimestamp < timestamp_iso(date(current timestamp -7
days))                

You may want to subtract 8 days ?



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: 16 February 2007 15:17
To: rpg400-l-bounces@xxxxxxxxxxxx; RPG programming on the AS400 /
iSeries
Subject: SQL date help



Mornin' everyone
I know I've seen a couple of articles dealing with dates in SQL, but I
am going nuts in trying to locate them.(Some would say I'm already
there) Anyway, what I have is a file with a timestamp as one of the
fields on the record showing the date that the record was created. What
I want to do in SQL, is obtain todays date as a timestamp, subtract 1
week (7 days) from that date and make that timestamp be midnight on
that, then delete all records on the file with a timestamp of less than
the calculated timestamp.
If anyone can either help me out as to how to obtain todays date in SQL,
it would be much appreciated.
Thanks in advance



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.