Home · Latest · Trends  /  SQL
5

MySQL update - Incorrect date value: 0000-00-00 00:00:00

rated 5 times [  5] [ 0]  / comments: 0 / hits: 1061  / 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
 
Share
Snippets
2 years ago, sun, aug 6, 2017
TinyMCE v 4 change default font style, font family, color...
2 years ago, tue, aug 22, 2017
CSS change bootstrap 4 tooltip color
2 years ago, tue, aug 22, 2017
Scroll to the top of the page button with jQuery
2 years ago, wed, aug 30, 2017
Posted
bigjoe

bigjoe

Member since Aug 6, 2017
Total Code Snippets: 5
Total Comments: 0
Location: n/a
Following
User not following anyone yet.