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.
