OPAL Time Functions

Time functions provide conversion to and from various time and date formats.

Function	Description
abs	Returns the absolute value of ‘val’.
avg	Calculate the arithmetic average of the input expression across the group.
bin_end_time	Returns the end time of the current bin (exclusive).
bin_start_time	Returns the start time of the current bin (inclusive).
deriv	Calculate the average per-second derivative of the argument across the group.
duration	Convert a number or timestamp, or a time interval, to a duration.
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.
duration_sec	Convert a number of seconds to a duration.
format_time	Format the timestamp value in UTC according to the specified format.
from_milliseconds	Given a numeric value representing milliseconds since epoch, return a timestamp of that point in time.
from_nanoseconds	Given a numeric value representing nanoseconds since epoch, return a timestamp of that point in time.
from_seconds	Given a numeric value representing seconds since epoch, return a timestamp of that point in time.
median	Return the fast approximate median value of one column.
median_exact	Return the exact median value of one column.
now	Returns the current time for which the query is executed as timestamp.
parse_isotime	Parse a YYYY-MM-DDTHH:MM:SSZ-formatted string as a timestamp.
parse_timestamp	Parse a string value, whose format is specified by the format argument, as a timestamp.
percentile	Returns an approximated value for the specified percentile of the input expression across the group.
percentile_cont	Assuming a continuous distribution, it returns the value for the specified percentile of the input expression across the group.
percentile_disc	Assuming a discrete distribution, it returns the value for the specified percentile of the input expression across the group.
query_end_time	Returns the latest time of the query time window.
query_start_time	Returns the earliest time of the query time window.
rate	Calculate the average per-second rate of the argument across the group.
row_end_time	Returns the value of the “Valid To” column, or null if the verb input dataset has no “Valid To” column.
row_timestamp	Returns the value of the timestamp column for Event datasets, the “Valid From” column for Interval or Resource datasets, or null
stddev	Calculate the standard deviation across the group.
sum	Calculate the sum of the argument across the group, or of the scalar arguments if more than one.
timestamp_null	Returns a null value of type timestamp.
valid_for	Specify the validity period for each event for some verbs