Loading

TOTIMESTAMP

conversion date
Configuration parameters

Converts a date in format ISO8601 into a timestamp in the platform's time unit.

The TOTIMESTAMP function consumes a string parameter (date + time + time zone) from the top of the stack and pushes back its conversion to a number of time units since the Unix Epoch.

The time unit depends on the platform configuration warp.timeunits (microseconds by default on a standalone).

The supported format is ISO8601 and are:

  • yyyy-mm-dddThh:mm:ss.ssssssZ
  • yyyy-mm-dddThh:mm:ss+hh:mm

As the string are URL encoded, the symbol + have to be replaced by %2B, otherwise a space will replace the + in the string.

TOTIMESTAMP is available since version 1.0.0.

Signatures

Examples

'2016-01-19T16:07:37Z' TOTIMESTAMP '2016-01-19T16:07:37%2B02:00' TOTIMESTAMP