Default Value to a DateTime Column

Hi everybody Has some way to set up a function, like now(), as a default value of an dateTime column. Is some thing like this. Create Table Persons ( PersonCode int(10) zerofill not null auto_increment, PersonName varchar(150) not null, CadastreDate DateTime not null default now(), Primary Key

Re: Default Value to a DateTime Column

At 9:30 PM -0300 3/13/07, allysonalves wrote: Hi everybody Has some way to set up a function, like now(), as a default value of an dateTime column. Is some thing like this. Create Table Persons ( PersonCode int(10) zerofill not null auto_increment, PersonName varchar(150) not null