Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 18, 2022
Send us feedback
day
Returns the day of month of the date or timestamp.
day(expr)
expr: A DATE or TIMESTAMP expression.
expr
An INTEGER.
This function is a synonym for extract(DAY FROM expr).
extract(DAY FROM expr)
> SELECT day('2009-07-30'); 30
dayofmonth function
dayofweek function
dayofyear function
hour function
minute function
second function
extract function