The problem record

In use go When writing project operation database in language , Because of my User There is a time field in the structure

type User struct {
    
	ID        uint      `gorm:"primary_key"`
	CreatedAt time.Time `gorm:"type:timestamp;not null"`
	UpdatedAt time.Time `gorm:"type:timestamp;not null"`
	UserName  string    `gorm:"type:varchar(20);not null" json:"username"`
	PassWord  string    `gorm:"type:varchar(20);not null" json:"password"`
	Role      int       `gorm:"type:int" json:"role"`
}

Then I made an error in updating the database

	err := db.Create(&data).Error

Error 1292: Incorrect datetime value: '2022-07-20 15:52:42.7744207' for column 'created_at' at row 1

From the perspective of error reporting, it is probably illegal because the type of value does not correspond to the value
So I changed the value type to datatime and timestamp
Neither. , So I went to check the information
resolvent
This link solves my problem , But what the owner of the link solves is that time cannot be 0, I also encountered at the beginning , Later, I didn't understand the solution, so I gave up the one that was originally in my project del_at Field .

The main cause of the problem is mysql Caused by the strict mode of .

resolvent

see sql_mode

#  View the current sql_mode
select @@sql_mode;
#  Look at the big picture sql_mode
select @@global.sql_mode;

mysql> select @@sql_mode;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@sql_mode                                                                                                                                |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
 
mysql> select @@global.sql_mode;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@global.sql_mode                                                                                                                         |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
 
mysql>

modify sql_mode

Don't write like the following , As long as you put your sql_mode Medium STRICT_TRANS_TABLES Just remove the field ok 了

#  Modify global 
set @@global.sql_mode = 'ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
#  Modify the current 
set @@sql_mode = 'ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';