When I enter CURRENT_TIMESTAMP in for my default value it gives me an invalid default value for 'edit time'
My type is int does this need to be different?
Anyone know what I can enter in to make this go away?
The error I get is "Invalid default value for 'edit_time' "
CURRENT_TIMESTAMP
Moderator: General Moderators
Re: CURRENT_TIMESTAMP
current_timestamp would be in the datetime or date format so your field type also needs to be either datetime or date
Re: CURRENT_TIMESTAMP
As far as I know, there's no way to make the current timestamp be a default value for a column. You can certainly make the default the timestamp for when you create the table, but not the timestamp for when a row is added.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Re: CURRENT_TIMESTAMP
Good point pickle 