DATEDIFF takes three arguments: a date part, a start timestamp, and an end timestamp. It returns the integer delta between the part of the two timestamps specified by the date part:The DateDiffMapper element is used to customize the mappings for the date parts listed in Table 11-11. The table also shows the default template for each date part.
Table 11-11 The following examples show different ways of mapping the DATEDIFF function with date part yyyy.
|
|
Copyright Actuate Corporation 2012 |