TalkPHP - View Single Post

Wildhoney · 06-02-2008, 09:42 PM

It'd be something like the following. Simply convert the date in the database to a unix timestamp on-the-fly, and compare it against the current timestamp.

sql Code:

DELETE FROM
    myTable
WHERE
    UNIX_TIMESTAMP(myLastActiveColumn) < UNIX_TIMESTAMP()

06-02-2008, 09:42 PM	#2 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	It'd be something like the following. Simply convert the date in the database to a unix timestamp on-the-fly, and compare it against the current timestamp. sql Code: DELETE FROM myTable WHERE UNIX_TIMESTAMP(myLastActiveColumn) < UNIX_TIMESTAMP() __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.