In Mysql (http://www.mysql.com/doc/en/Date_and_time_functions.html) funnily enough:
NOW() or SYSDATE() will return what you want. Regards M -----Original Message----- From: Arthur [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 12:56 To: MYSQL Subject: Insert default Date Hello MYSQL, In access Now() as table field default sets the field when a new record is created. In SQL Server there is getdate() & suser_sname() Is there an equivalent for MySQL? -- Best regards, Arthur mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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
