datetime_part

The datetime_part function extracts the requested date part as an integer value.

Syntax

​

    datetime_part( Part, Datetime )

Arguments

​

• Part: Possible values are: Year, Quarter, Month, week_of_year, Day, DayOfYear, Hour, Minute, Second, Millisecond, Microsecond, Nanosecond.
• Datetime: A datetime.

Returns

​

An integer representing the extracted part.

week_of_year returns an integer that represents the week number. The week number is calculated from the first week of a year, which is the one that includes the first Thursday.

Examples

​

Let dt = datetime(2017-10-30 01:02:03.7654321) in the following examples:

• year = datetime_part("year", dt)
• quarter = datetime_part("quarter", dt)
• month = datetime_part("month", dt)
• weekOfYear = datetime_part("week_of_year", dt)
• day = datetime_part("day", dt)
• dayOfYear = datetime_part("dayOfYear", dt)
• hour = datetime_part("hour", dt)
• minute = datetime_part("minute", dt)
• second = datetime_part("second", dt)
• millisecond = datetime_part("millisecond", dt)
• microsecond = datetime_part("microsecond", dt)
• nanosecond = datetime_part("nanosecond", dt)