OQL DATEDIFF
1 Description
The DATEDIFF
function returns the difference between two given date/time values. The difference is given in the specified unit.
2 Syntax
The syntax is as follows:
|
|
2.1 unit
unit
specifies the unit of the date/time value to retrieve. This can be one of the following:
YEAR
, QUARTER
, MONTH
, DAY
, WEEK
, HOUR
, MINUTE
or SECOND
. For more information on date/time values, see the Example section in OQL DATEPART.
2.2 startdate_expression
startdate_expression
specifies the start date of the period being calculated. This should be formatted in an expression which resolves to a date/time value.
2.3 enddate_expression
enddate_expression
specifies the end date of the period being calculated. This should be formatted in an expression which resolves to a date/time value.
2.4 timezone
timezone
specifies the time zone to use for the retrieval. This parameter is optional and defaults to the local time zone. It should be a string literal containing an IANA time zone. GMT offset time zones are not supported.
Feedback
Was this page helpful?
Glad to hear it! Thank you for your response.
Sorry to hear that. Please tell us how we can improve.