Re: Default DATE field values

2004-01-04 Thread Chris Nolan
;t want it update > when you UPDATE the row, you can just set it to its current value, if > you weren't aware of that. > > > Matt > > > - Original Message - > From: "Chris Nolan" > Sent: Saturday, January 03, 2004 10:34 AM > Subject: Defau

Re: Default DATE field values

2004-01-03 Thread Matt W
rrent value, if you weren't aware of that. Matt - Original Message - From: "Chris Nolan" Sent: Saturday, January 03, 2004 10:34 AM Subject: Default DATE field values > Hi all, > > Upon reading the funky manual, I have discovered the following things: > >

Default DATE field values

2004-01-03 Thread Chris Nolan
Hi all, Upon reading the funky manual, I have discovered the following things: 1. TIMESTAMP fields can be set so that their default value is NOW(). 2. DATE and TIMESTAMP fields are related. Given the two above facts, is there a way to set DATE columns so the default value is NOW()? My playing ar