6
MySQL update - Incorrect date value: 0000-00-00 00:00:00
rated 6 times
[
6]
[
0]
/ comments: 0 / hits: 1211
/ 2 years ago, sun, aug 6, 2017, 05:31:35
MySQL error when update default value for DATETIME
UPDATE `users` SET `lastdate`='2017-01-01 00:00:00';
ALTER TABLE `users` CHANGE `lastdate` `lastdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
More From
» SQL
Comments
There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account
Posted
bigjoe
Member since Aug 6, 2017
Total Code Snippets: 5
Total Comments: 0
Location: n/a