Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Atualizado 07/10/2024
Send us feedback
dayofmonth
Applies to: Databricks SQL Databricks Runtime
Returns the day of month of the date or timestamp. This function is a synonym for extract(DAY FROM expr).
extract(DAY FROM expr)
dayofmonth(expr)
expr: A DATE or TIMESTAMP expression.
expr
An INTEGER.
> SELECT dayofmonth('2009-07-30'); 30
day function
dayofweek function
dayofyear function
hour function
minute function
second function
extract function