Shulou(Shulou.com)06/01 Report--

Next_day () gets the date of the next week of the current date, which is easily understood literally as the date of the next few days of getting the current date. For example: select next_day (to_date ('20160330 recording recording yyyymmdd`), 1) from dual; returns a result of 20160403. The parameter can be the number 1-7 or the date on which monday-sunday gets the day of the next week.

Another commonly used oracle date function: add_months () gets the date a few months before or after the current date. When the parameter is positive to get the current date plus a few months of the date, when the parameter is negative to get the current date minus the date of the corresponding month.

For example: select add_months (to_date ('20160330century grammdd`), 1) from dual; returns a value of 20160430

The return value of select add_months (to_date ('20160330) grammdd`),-1) from dual; is 20160229

If the date of the current month is greater than the date of the conversion month, for example, when March 30 31 is converted to the previous month, since there are only 29 days in February, the return value for the date of March 29 minus one month is 20160229.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.