Dates & time
Scalar
dayofmonth()
Extract the dayofmonth component from a date or timestamp
Reference: DuckDB 2.0.0
Arguments & returns
4 overloadsdayofmonth(ts)
Scalar
Example
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.
In other engines
Prestoday_of_month()
DAY_OF_MONTH(timestamp '2012-08-08 01:00:00')
DAYOFMONTH(CAST('2012-08-08 01:00:00' AS TIMESTAMP))