sheepeatingtaz : MySQL default date values

{ 2007 12 07 }

MySQL default date values

Is it possible to set the default value of a datetime MySQL field to todays date + 30?

If so, how?!?

Posted by sheepeatingtaz on Friday, December 7, 2007, at 10:46 am. Filed under Computers, Tech. Follow any responses to this post with its comments RSS feed. You can post a comment or trackback from your blog.

Kirrus | December 7, 2007 at 12:11 pm | Permalink

I don’t think so; I’ve not found anything that can do that type of logic anyway…

You might try the DATEADD command… also, the MySQL doc page might be useful:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

HTH…
sheepeatingtaz | December 7, 2007 at 12:18 pm | Permalink

Yeah, I tried setting the default value as DATE_ADD(CURDATE(), INTERVAL 30 DAY) but I get an invalid sql error…

Thanks Anyway!