Jump to content

[SOLVED] Enter a date into MYSQL + 2 weeks


fry2010

Recommended Posts

just another one while your here, say I wanted to then check those dates I put into it, so like :

 

Person registers. expire is set to 2 weeks from now. I check this expiry date when they go to another part of the site, with todays date.

thanks jitesh, but i have tried using those with INSERT and it doesnt work.

It seems the only way to use DATE_ADD and INTERVAL is through a SELECT statement because there is nothing in the docs about INSERTING this information. Not that i can make out anyway.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.