Re: mysql to mssql query

[Gabriel Ricard]

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 know the equivalent of this query in mssql:

SELECT * FROM myTable WHERE date_field >= DATE_SUB('2003-10-19', 
INTERVAL 7
DAY);

For this project we are pulling records off a MS SQL db, and I need to
figure a way to return all records for the week.
Any help is appreciated.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]