mssql date compare to date()

[atdawgie]

I'm trying to compare a field of type datetime in mssql 7 to date("mdY")

$today = date ("mdY");

select * where 'MYDATE' >= '$today'

But it always returns all records rather than those greater or equal to today's date.

Should I be doing this using the php date function or is there a better way to do it with a sql query?

Thanks,

Aaron

[sevex]

you'll probably wanna take the single quotes off of 'MYDATE', and tell it what table to select from.

I've never actually used mssql, but it probably has a function that will return the current time. You could compare that.

In mysql this would look like:

"SELECT * FROM mytable WHERE mydate >= CURRENT_TIMESTAMP"

[Anon]

try

..WHERE TO_DAYS(MYDATE) >= TO_DAYS(GETDATE())