OPAL Time Functions¶
Time functions provide conversion to and from various time and date formats.
Function |
Description |
---|---|
Returns the absolute value of ‘val’. |
|
Calculate the arithmetic average of the input expression across the group. |
|
Returns the end time of the current bin (exclusive). |
|
Returns the start time of the current bin (inclusive). |
|
Calculate the average per-second derivative of the argument across the group. |
|
Convert a number or timestamp, or a time interval, to a duration. |
|
Convert a number of hours to a duration. |
|
Convert a number of minutes to a duration. |
|
Convert a number of milliseconds to a duration. |
|
Returns a null value of type duration. |
|
Convert a number of seconds to a duration. |
|
Format the timestamp value in UTC according to the specified format. |
|
Given a numeric value representing milliseconds since epoch, return a timestamp of that point in time. |
|
Given a numeric value representing nanoseconds since epoch, return a timestamp of that point in time. |
|
Given a numeric value representing seconds since epoch, return a timestamp of that point in time. |
|
Return the fast approximate median value of one column. |
|
Return the exact median value of one column. |
|
Returns the current time for which the query is executed as timestamp. |
|
Parse a |
|
Parse a string value, whose format is specified by the |
|
Returns an approximated value for the specified percentile of the input expression across the group. |
|
Assuming a continuous distribution, it returns the value for the specified percentile of the input expression across the group. |
|
Assuming a discrete distribution, it returns the value for the specified percentile of the input expression across the group. |
|
Returns the latest time of the query time window. |
|
Returns the earliest time of the query time window. |
|
Calculate the average per-second rate of the argument across the group. |
|
Returns the value of the “Valid To” column, or null if the verb input dataset has no “Valid To” column. |
|
Returns the value of the timestamp column for Event datasets, the “Valid From” column for Interval or Resource datasets, or null |
|
Calculate the standard deviation across the group. |
|
Calculate the sum of the argument across the group, or of the scalar arguments if more than one. |
|
Returns a null value of type timestamp. |
|
Specify the validity period for each event for some verbs |