To: Cal Evans; MYSQL
Subject: RE: Default Date value
Is it possible to set a function as a default value for a column at all.
I apologize if I come off a bit dumb about this but I come from an MSSQL
background where you can set a default to a function.
Thanks Again
-Original Message-
From
Title: Blank
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
: 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
, March 25, 2001 4:06 PM
To: Michael Blood; MYSQL
Subject: RE: Default Date value
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