Filter
Top Products
Example 3:
For orders that are one month old or older in the ORDERTBL table, the corresponding order numbers
are obtained from the order table according to the specified order day. The current date is 2000-08-01.
By using the ADD_DATE function, dates can be added, where YEAR, MONTH, or DAY is used as the
unit of addition for the time interval. The added number can be defined as a number of years, months,
or days.
Example 4:
A number of days ranging from the order day until the end of month is obtained.
114