parseTimestamp

Return a timestamp from a string given a time and date format.

Example

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

Syntax

parseTimestamp(string expr date, string mask)
  • date : expression evaluating to string
  • mask : string describing date format

    Returns

    timestamp

Notes

This function takes in a string date (the first parameter), whose format has to match the string mask (the second parameter) and returns it as a date type in a format matching the logged-in user locale preferences. The function takes any valid java mask.