How to delete rows in mysql whose dates are older than 5minute

PHP
23

What ever the users time zone is or maybe tomorrow is what i put inside the database, my date column is just a datetime column set to null without current stamp enabled in it, so all my insert into that column is what ever the users php timezone generates. So dates stored in that column will start receiving new time zones anytime the users server time zones changes.

Also it does work in line with some of my php timeszone.

So see my approach as a simple pen and paper made to manually write down dates without timezones conflicts

24

Thanks a million times @m_hutley

I got the clue.

echo date(ā€˜Y-m-d H:i:sā€™, 1128297203);

25

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.