MySQL Forums
Forum List  »  General

Re: Why is STR_TO_DATE failing?
Posted by: Peter Brawley
Date: July 22, 2022 06:59AM

[quot]
`AnswerDate` date DEFAULT NULL,
`AnswerTime` time DEFAULT NULL,
`AnswerDateTime` datetime DEFAULT NULL,
[/quote]

The first two are redundant and invite skew. Not sound. Consider replacing them with GENERATED columns (ie auto-generated from the datetime column).

Options: ReplyQuote


Subject
Written By
Posted
Re: Why is STR_TO_DATE failing?
July 22, 2022 06:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.