Re: Setting a default time in mysql table def

At 21:14 -0400 4/8/02, Carl Schmidt wrote: > If I set a mysql table def time to default like so: > > eventTime time NOT NULL DEFAULT '0'; > > Will it default to the current time like the TIMESTAMP does? If not, is > it possible with something like CURTIME() to make this happen? No. > > Car

Setting a default time in mysql table def

If I set a mysql table def time to default like so: eventTime time NOT NULL DEFAULT '0'; Will it default to the current time like the TIMESTAMP does? If not, is it possible with something like CURTIME() to make this happen? Carl --