dateDiff Arggh! can't get it to work please help.

[skip]

Hello all,

can someone please help me out I need to know if this is correct ?

SELECT * from orders where DATEDIFF('order_renew_date, now()') < 60

Or !

SELECT *, DATEDIFF('order_renew_date, now()') as date_result from orders where date_result < 60

Thanks all in advance

[nnichols]

When passing arguements to functions they should only be quoted if they are string literals. The latest date should go first otherwise it will return a negative value.
If you are looking for renewals due within the next 60 days -

SELECT * FROM orders WHERE DATEDIFF(NOW(), order_renew_date) < 60

You should read the manual entry before posting - dev.mysql.com