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
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
.
parseTimestamp("2001-12-24 23:05:33.000","yyyy-MM-dd HH:mm:ss.SSS")