Default a Date column to Date of INSERTION (MySQL)

Printable View

Nov 4th, 2005, 01:12 AM
SkiNLaB

Default a Date column to Date of INSERTION (MySQL)

How? I can only see Timestamp, which updates on update.
Nov 7th, 2005, 02:02 AM
dee-u

Re: Default a Date column to Date of INSERTION (MySQL)

Couldn't you set what would be the default value?
Nov 7th, 2005, 07:43 PM
SkiNLaB

Re: Default a Date column to Date of INSERTION (MySQL)

Only to a real value, I can't set it to a function it seems, ideally NOW()
Nov 7th, 2005, 07:50 PM
dee-u

Re: Default a Date column to Date of INSERTION (MySQL)

I am not sure but have you tried GetDate? Or perhaps Date?

All times are GMT -5. The time now is 11:04 AM.