Filter
Top Products
Example 2:
The number of days that have been elapsed from the order date to the current date is obtained from
the ORDERTBL table. The current date is 2000-08-10.
By using the SPAN_DATE function, the difference (time interval) between dates can be obtained,
where YEAR, MONTH, or DAY is used as the unit for the time interval. Users can also obtain the
number of times the year, month, or day changes between dates.
113