If what you are looking for is the current date to be used as date of creation, then remain unchanged, you will have to specify sysdate as a value during an insert. You may benefit from the timestamp datatype, which sets itself to the current date when any DML statements (insert, update) are performed.
Mike -----Original Message----- From: Chugh Shalini [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 6:41 AM To: [EMAIL PROTECTED] Subject: sysdate or curdate as default date in mysql Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, mysql, query --------------------------------------------------------------------- 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
