extract_time

XQL_function_descriptions.json

Synopsis

extract_time(field: timestamp, part: "DAYOFYEAR" / "DAY" / "DAYOFWEEK" / "HOUR" / "MINUTE" / "SECOND" / "MILLISECOND" / "MICROSECOND")

Description

This function returns a value that corresponds to the specified part from a supplied datetime expression. Allowed part values are: "DAYOFYEAR", "DAY", "DAYOFWEEK", "HOUR", "MINUTE", "SECOND", "MILLISECOND", "MICROSECOND".