How To Set Default Value to Now() ??? - Any Ideas ???

[MarkDicken]

I have a DateEntered Field and it is DATETIME. Is is possible to ask the default value to be Current Date And Time that the record was added.

I have managed to manually do this with PHP but I would like the Date/Time stamping to be done on the database end not the front end

Many Thanks In Advance ...

 

[sophisticate]

Try to change the column type to TIMESTAMP and give it an attribute of NOT NULL. I'm of the understanding that the default value will automatically be set to the current time of the record addition.

brendanc@icehouse.net

 

[MarkDicken]

Thanks I'll give it a try, I did not know of a Field Type called TimeStamp existed ....

Cheers ...

Mark Dicken