Subtracting Dates

[Meltdown]

I want to subtract todays Date from a deadline Date stored in a MySQL database, I want to do it in the sql string that is pulling the data. I tried numerous combinations and can't seem to get it right.

This is the part thats failing:

$date1('y m d',deadline) - $date2('y m d') AS daysleft

Appreciate any help.

[devinemke]

read up on mySQL's Date and Time Functions, specifically DATEDIFF().

[Meltdown]

Hi, thanks for the reply, this is what i get when I try to use DateDiff

Error:"Call to undefined function DateDiff()"

do you know what is causing that error?

[thorpe]

post your code. that looks like a php error, so maybe you've not got that in your sql statement properly.

[Meltdown]

Thanks for the reples, I finally got it to work, but not with DateDiff.

For future reference I used:
TO_DAYS(deadline) - TO_DAYS(NOW()) AS daysleft