Checking for expired accounts.

[TreacherousDog]

Hi,
This is a really simple question. Basically I have this system that creates temporary accounts. The time the account is created is stored in that accounts record in a mySql DB as a datetime field. This is the format (2003-10-21 16:16:18).

Basically I want my login function to grab this value and check to see if it's over 30 days since the account was created. I know how to grab the value etc.. I'm just not sure how to check if it's 30 days old or not. Would it be better to use a regular timestamp field instead?

[Weedpacket]

Using a datetime field in a MySQL database suggests using MySQL date and time functions. Like, maybe, DATE_ADD, to add 30 days to the field in question and see if the result still lies in the future or has already passed; i.e., >NOW() or not.