RE: Default Date value

2001-03-26 Thread Cal Evans
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

Default Date value

2001-03-25 Thread Michael Blood
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

RE: Default Date value

2001-03-25 Thread Cal Evans
: 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

RE: Default Date value

2001-03-25 Thread Michael Blood
, 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