Well, even if you don't find an alternative for that syntax, you could
always do the date subtraction in application space and make the query
like this:
SELECT * FROM myTable WHERE date_field = '2003-10-12'
- Gabriel
On Tuesday, October 21, 2003, at 05:49 PM, DevList wrote:
Does anybody
If I understand your question correctly, you're wanting to grab the
records where the date is greater than or equal to a date plus 7 days.
If so, then:
SELECT * FROM myTable WHERE date_field = CAST('2003-10-19' AS DATETIME)
+ 7
Or you can use the DATEADD function:
SELECT * FROM myTable WHERE
Oops, you are subtracting the date, so use - 7 instead of + 7...
Dan
-Original Message-
From: Dan Lampkin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 5:05 PM
To: 'DevList'; 'mySQL Mailing List'
Subject: RE: mysql to mssql query
If I understand your question correctly