Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Feb 10, 2025
Send us feedback
second
Applies to: Databricks SQL Databricks Runtime
Returns the second component of the timestamp in expr.
expr
second(expr)
expr: A TIMESTAMP expression.
TIMESTAMP
An INTEGER.
INTEGER
This function is equivalent to int(extract(SECOND FROM timestamp)).
int(extract(SECOND FROM timestamp))
> SELECT second('2009-07-30 12:58:59'); 59
extract function
hour function
minute function