Jim, What you're asking about is the "timestamp" data type.
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.... > > Hi all... > > This is my first post to the list. I've been working on MySQL > now for about a > week and really like it. I have a question that I can't find > in any of the > books or how-tos. > > When I add a line to my customer's table I need it to put > today's date in the > "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