Converting Date&Time into Seconds

[kumschick]

Hi,

I need a script that checks if the entrie in the database is older then 12hours, if yes, then it deletes it!

my idear was to convert the date&time that was saved into the database and convert this into seconds and then do the same with the actual date&time.

example:
2004-03-25 12:40:00 (DEL)
2004-03-25 23:51:21 (KEEP)
2004-03-26 00:03:20 (NOW)

if the defrence is bigger then 43200sec. then "DELETE FROM $shop WHERE ..."

Or is there an better way?

Thx for helping...

[csn]

date_sub() should do what you need.

[kumschick]

I was on the mysql website and checked for this function, but since this i new to me, and i never worked with dates in mysql i do not understand a word. it's chiness for me! 😕

http://www.mysql.com/doc/en/Date_and_time_functions.html

Could someone help me little more please!

Thx

[Sxooter]

What you wanna do is something like:

delete from table where timefield < now() - interval '12 hours'

But I'm not sure MySQL supports that syntax yet.

[kumschick]

the syntax was not 100% correct, but the problem was quickly solved thx to you :p

it's "DELETE FROM $shop WHERE date< NOW() - INTERVAL 12 HOUR"