BlankI don't think you can do that with a default value. You will need to
include the current date in your insert statement.
Cal
http://www.calevans.com
-----Original Message-----
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 5:30 PM
To: MYSQL
Subject: Default Date value
I am trying to set the default value in a date field to be the time that
it was created
However I do not want the field to be a timestamp because I want to update
it to a different value later.
I have looked through the mysql documentation and I can not seem to find
anywhere that explains how to set the default value of a column = to a
function.
Anyone have any help?
Thanks in advance
Michael Blood
Matraex Technologies
[EMAIL PROTECTED]
