question on dealing with the mysql timestamp feild
Posted: Tue Jan 20, 2004 6:04 pm
im looking at the manual entry for timestamp and it's not clearing thisup for me. i have a table where i use it to find out when a user requested an email verification and want to delete those that are more then 24 hours old.
i set something up and currently have for a sql statement: DELETE FROM tabl WHERE timestampfeild<(NOW()-(24*60*60))
thing is i don't know how the timestamp feild works. can any of the db gurus tell me if that would remove all entries more than 24 hours old?
if not, where is the failure in my thought rocess of doing that and what do i need to know to correct it? and do you have any refrences aside fomr the mysql manual from mysql.com that i can use in the future?
i set something up and currently have for a sql statement: DELETE FROM tabl WHERE timestampfeild<(NOW()-(24*60*60))
thing is i don't know how the timestamp feild works. can any of the db gurus tell me if that would remove all entries more than 24 hours old?
if not, where is the failure in my thought rocess of doing that and what do i need to know to correct it? and do you have any refrences aside fomr the mysql manual from mysql.com that i can use in the future?