Time and Date Instructions

Instruction

Action

DATETIME

Return the components of a date and time string.

DATETIMESTRING

Convert a time and date (stored as a DOUBLE) to a string.

DATETIMEVALUE

Convert a timestamp into the corresponding numeric value as the number of milliseconds since 1970.

TOHMS

Convert a value in seconds to the format Hours:Minutes:Seconds.