MySQL Forums
Forum List  »  MySQL Workbench

Re: Add different frequency days to dates
Posted by: Arrie Schoeman
Date: May 10, 2022 04:00AM

I don't know if it is possible to have it in the table. I thought if I can get a formula in the "default" to do the calculation then it is in the table.
Table is assetno, asset_type, cur_date, frequency, base_date. (insp_date)
base dates are different and frequency are also different.
i.e. base date 2021-07-12 freq. is 182 days until next inspection.
2020-11-15 freq 750 days.
So interval can't work because of the different frequency days.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Add different frequency days to dates
68
May 10, 2022 04:00AM


Sorry, only registered users may post in this forum.

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.