# CURRENT\_DATE And CURDATE

Returns the current date.

## Syntax

```
CURRENT_DATE()
CURDATE()

```

## Return Type

Date object.

## Remarks

`CURDATE()` and `CURRENT_DATE()` functions are synonyms to each other. Both the functions return the current date in either `YYY-MM-DD` (string) or `YYYYMMDD` (numeric) format.

## Examples

The following functions return the current date in string format.

```sql
SELECT CURRENT_DATE(), CURDATE();

```

```output

+-------------------------------------------------------------+
| CURRENT_DATE()               | CURDATE()                    |
+-------------------------------------------------------------+
| 2019-03-22                   | 2019-03-22                   |
+-------------------------------------------------------------+

```

**Related Topics**

* [CURRENT\_TIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-timestamp.md)
* [CURRENT\_TIME And CURTIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-time-and-curtime.md)
* [Data Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types.md)
* [DATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/date.md)

***

Modified at: May 31, 2023

Source: [/db/v9.1/reference/sql-reference/date-and-time-functions/current-date-and-curdate/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-date-and-curdate/)

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