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

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

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.