Time difference in days

Anon

I have a mySQL database with a 'datetime' field containing a unix timestamp.
At this moment i'm stuck in creating a script that checks whether if the difference in days between today and the date stored in the database is 28 or not.
Could someone help me to get back on the track 🙂

Anon

Hi Robbert (sure with the two "b"s ?),

the unixtimestamp is the time in seconds (starting on the 01.01.1970 , 00:00 GMT) so you just have to take 60 x 60 x 24 x 28 and you've got your 28 days (as a unixtimestamp value) comparing them with your date and the actual timestamp (time()) should not cause too much trouble... of course you can make things a bit more difficult if you don't want 28 days to be 28 days X 24 hours X 60 minutes X 60 seconds (i.e. today to 28 days in the future without caring about the time of day...) sorry for the bad english but i haven't discussed any mathproblems in english till now....

cya Robert

Anon

you could try using the sql to_days(date) function, which returns the number of days from the current date until 'date'.

the date /can/ be a timestamp, but i don't know if the function will be happy returning a negative number or not ;-) you'll just have to suck it and see :-)

failing this try some expression involving the from_unixtime() sql function.

--
rad