Built-in Functions → parseTimestamp

parseTimestamp() is a conversion function that evaluates a string date expression (the first parameter), whose format has to match the string mask (the second parameter) and returns a timestamp.

Signature

Copy
parseTimestamp(string exp, string mask)

• string exp : an expression evaluating to string date
• string mask : string describing date format

Returns

timestamp

Example

Convert "2001-12-24 23:05:33.000" with format "yyyy-MM-dd HH:mm:ss.SSS" to type timestamp.

Copy
parseTimestamp("2001-12-24 23:05:33.000",
                    "yyyy-MM-dd HH:mm:ss.SSS")