Skip to main content

timestamp function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Casts expr to TIMESTAMP. This function is a synonym for CAST(expr AS TIMESTAMP). For details see cast function.

Syntax

timestamp(expr)

Arguments

  • expr: Any expression that can be cast to TIMESTAMP.

Returns

A TIMESTAMP.

Examples

SQL
> SELECT timestamp('2020-04-30 12:25:13.45');
2020-04-30 12:25:13.45
> SELECT timestamp(date'2020-04-30');
2020-04-30 00:00:00
> SELECT timestamp(123);
1969-12-31 16:02:03