floridaflatlander Posted November 30, 2011 Share Posted November 30, 2011 Currently I have a database with a timestamp NOT NULL column called date_reg, whenever I edit the record the time changes, I've tried to change the column type to datetime but I get an error “1067 invalid default value for date_reg mysql”. As I understand it, if I have two timestamp columns only the first one is changed when a record is updated. I have the option of adding another timestamp column in front of the current timestamp column and call it last_edited, is there any other options? Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.