Built-in Functions → timestamp

timestamp() is a conversion function that returns a timestamp from a string expression.

Note

The string expression must be in the format "yyyy-MM-dd HH:mm:ss. SSS". The timestamp is returned in a format according to the logged-in user locale preferences. To change the returned timestamp format, use the formatDate(date exp, string mask) function.

Signature

timestamp(string exp)
  • string exp : a string expression representing time

Returns

timestamp

Example

Convert the string, "2001-12-24 23:55:12.000", into a timestamp.

timestamp("2001-12-24 23:55:12.000")