MySQL Forums
Forum List  »  MySQL Workbench

Re: Add different frequency days to dates
Posted by: Peter Brawley
Date: May 11, 2022 10:08PM

If adding ints to dates were sufficient for date arithmetic of the sort you're trying to implement, MySQL wouldn't need functions like Date_Add().

The Default clause doesn't accept functions, so it's inadequate for your requirement. I think you'll need a Generated column, with a Date_Add() call.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Add different frequency days to dates
393
May 11, 2022 10:08PM


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.