Built-in Functions → day
day() is a scalar date function that returns the day of the month from a date or timestamp.
Signature
day(date exp)
The following table illustrates the day() parameter:
| Parameter | Description |
|---|---|
| date exp | expression evaluating to date |
Returns
int
Example
day(date("2001-12-24 23:55:12.000"))
This example returns 24.