datetime_part()

Extracts the requested date part as an integer value.

Syntax

datetime_part(part,datetime)

Parameters

Possible values of part

• Year
• Quarter
• Month
• week_of_year
• Day
• DayOfYear
• Hour
• Minute
• Second
• Millisecond
• Microsecond
• Nanosecond

Returns

Returns an integer representing the extracted part.

Examples

The following example extracts the year, quarter, month, week of year, day, day of year, hour, minute, second, millisecond, microsecond, and nanosecond from a specified datetime value.

let dt = datetime(2017-10-30 01:02:03.7654321); 
print 
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)

Output