Re: SQL Minus 7 days from current date
- From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
- Date: Mon, 30 Apr 2007 22:20:13 +0530
Hello,
SELECT GETDATE()-7
Thanks
Hari
"RFrechette" <RFrechette@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:575C3EC7-DB74-4634-88C1-21DC0000C48F@xxxxxxxxxxxxxxxx
How would I subtract 7 days from the current date?
I can't seem to get the syntax correct?
Thank you,
Rachel
.
- Prev by Date: Re: Query for reordering tables
- Next by Date: Re: SQL Minus 7 days from current date
- Previous by thread: Re: Query for reordering tables
- Next by thread: Re: SQL Minus 7 days from current date
- Index(es):
