Jim,=20 What you're asking about is the "timestamp" data type. =20
Look at : http://www.mysql.com/doc/D/A/DATETIME.html In a nutshell, if you assign 'null' to a timestamp column it will put in value of 'NOW()'. Eric Mayers Software Engineer > -----Original Message----- > From: Jim Hatridge [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 9:50 AM > To: [EMAIL PROTECTED] > Subject: Hello! Date question.... >=20 > Hi all... >=20 > This is my first post to the list. I've been working on MySQL=20 > now for about a=20 > week and really like it. I have a question that I can't find=20 > in any of the=20 > books or how-tos. >=20 > When I add a line to my customer's table I need it to put=20 > today's date in the=20 > "indate" column. Is there anyway to do this like the auto for numbers? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
