OQL DATEPART

Description

The DATEPART function retrieves a specified element from a date/time values. This element is of type integer.

Syntax

The syntax is as follows:

DATEPART ( datepart , date_expression [, timezone ] )

datepart

datepart specifies the part of the date/time value to retrieve. For possible values, see the Example below.

date_expression

date_expression specifies the date to retrieve an element from. This should be formatted in an expression which resolves to a date/time value.

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.

Example