Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Duplicate
-
Affects Version/s: 10.3.27
-
Fix Version/s: N/A
-
Component/s: Data Manipulation - Insert, Time zones
-
Labels:None
-
Environment:linux
Description
NOW()+INTERVAL 1800 SECOND produces invalid date.
Having a table with a column
`valid` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
and an insert statement like this
REPLACE INTO tblCaptcha SET `valid`=NOW()+INTERVAL 1800 SECOND
produces the following error at 2021-03-28, 01:30:08
Incorrect datetime value: '2021-03-28 02:00:08' for column `tblCaptcha`.`valid` at row 1
Attachments
Issue Links
- is duplicated by
-
MDEV-15750 preserve MYSQL_TYPE_TIMESTAMP in temporal arithmetic
-
- Open
-