MySQL compare dates against strtotime?

[Perad]

I have a datetime column in the mysql database. I am trying to get posts from the last 2 days. Do I have to convert the time into the db format? If so is there a dedicated function to do this or have I got to create it with the date function.

[DyslexicDog]

strtotime("-2 days");

[DarkWater]

Use the SUBDATE() function.

 

SELECT * FROM posts WHERE date >= DATESUB(NOW(), INTERVAL 2 DAYS);

 

That should work I think.

[TransmogriBenno]

I think it's

SELECT * FROM posts WHERE date >= DATE_SUB(NOW(), INTERVAL 2 DAY);

 

Also, I highly recommend doing date comparisons either all in SQL or all in PHP, since the times (on a badly configured server) may be different in the two contexts. I've seen it happen before.

[DarkWater]

@TransmogriBenno: Indeed it is.  I was going to write SUBDATE instead of DATESUB but I wasn't paying attention.  Both SUBDATE and DATE_SUB are valid functions though. @_@  Thanks for that correction.