Skip to main content
Last updated on

time_from_millis function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 18.3 and above

Creates a TIME value from the number of milliseconds since midnight.

Syntax​

time_from_millis(expr)

Arguments​

  • expr: An integral numeric expression representing milliseconds since midnight (0 to 86399999).

Returns​

A TIME.

Examples​

SQL
> SELECT time_from_millis(52200500);
  14:30:00.500000

> SELECT time_from_millis(0);
  00:00:00
On this page