OPAL Time Functions

Function

Description

bin_end_time

Returns the end time of the current bin (exclusive)….

bin_start_time

Returns the start time of the current bin (inclusive…

duration

Convert a number or timestamp, or a time interval,…

duration_hr

Convert a number of hours to a duration.

duration_min

Convert a number of minutes to a duration.

duration_ms

Convert a number of milliseconds to a duration.

duration_null

Returns a null value of type duration. This is…

duration_sec

Convert a number of seconds to a duration.

format_time

Format the timestamp value in UTC according to the…

from_milliseconds

Given a numeric value representing milliseconds…

from_nanoseconds

Given a numeric value representing nanoseconds since…

from_seconds

Given a numeric value representing seconds since…

parse_isotime

Parse a YYYY-MM-DDTHH:MM:SSZ-formatted string as a…

query_end_time

Returns the latest time of the query time window.

query_start_time

Returns the earliest time of the query time window.

row_end_time

Returns the time at which the state in the row…

row_timestamp

Returns the timestamp (start time) of the row.

timestamp_null

Returns a null value of type timestamp. This is…

valid_for

Specify the validity period for each event for some…