Expressions > Syntax rules > Functions

STR_TO_TIME function

Convert an ISO 8601 formatted string to an Epoch Time value (the number of seconds since midnight, Jan. 1, 1972).

Syntax:

'external reference' := STR_TO_TIME("ISO time string");

ISO Formatted String to Convert to Local Epoch Time:

"YYYY-MM-DDThh:mm:ss"

Where:
YYYY = year
MM = month
DD = day of month
hh = hour
mm = minutes
ss = seconds

Example:

(* get the local timefor an ISO-8601 time string *)
'/LOCAL_TIME' := str_to_time("2002-12-09T12:45:00");

The above example shows how to convert the ISO 8061 time string corresponding to December 9, 2002, 12:45 am to an Epoch time value. The example returns 976365900.