# DAY

Extracts the day of the month from the given datetime.

## Syntax

```
DAY ( dateobj )

```

## Arguments

* dateobj: a valid date, datetime, or parsable date string.

## Return Type

Integer

## Examples

```sql
SELECT DAY('2009-02-13');

```

```output

+-------------------+
| DAY('2009-02-13') |
+-------------------+
|                13 |
+-------------------+

```

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/day/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/day/)

(An index of the documentation is available at /llms.txt)