'Daylight Saving Time MySql unable to add 1 day
Adding 1 day to the MySQL EST TIMESTAMP column error if it lands in between the daylight adjustment hour. Any way around it other than catch exception and then add an extra hour?
The insert query adds a day: CURRENT_TIMESTAMP + INTERVAL 1 DAY
That gives error when it lands on an invalid day light time of the day:
com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2022-03-13 02:29:00' for column 'revoked' at row 1
The column is EST which is consistent with other TIMESTAMP columns in our database.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|