[RESOLVED] Date problem

MichaelHe

I have a little date problem...

A date is put in a mysql table, date/time field.
Now I have to check if a date/time in the table is more than 1 day old.

So if it says 2007-06-28 21:58:14 it is not 1 day old yet.

I get the date/time like this

select DATE_FORMAT(Date, '%d/%m-%Y %H:%i:%s') AS Dato from ...... LIMIT 1

But how do I check if it's more than a day old ?

nemonoman

The name of your date/time column is Date ???

SELECT Date< Date - INTERVAL 1 DAY
FROM mytable
WHERE blah blah blah

Will return 1 if the date Date is more than 1 day old.

You can add this to your current select
SELECT DATE_FORMAT(Date, '%d/%m-%Y %H:%i:%s') AS Dato ,
Date< Date - INTERVAL 1 DAY AS DayOld
FROM ...... LIMIT 1

MichaelHe

Perfect.. thank you very much 🙂