# CURRENT\$1DATE
<a name="sql-reference-current-date"></a>

Returns the current Amazon Kinesis Data Analytics system date when the query executes as YYYY-MM-DD when the query executes.

For more information, see [CURRENT\$1TIME](sql-reference-current-time.md), [CURRENT\$1TIMESTAMP](sql-reference-current-timestamp.md), [LOCALTIMESTAMP](sql-reference-local-timestamp.md), [LOCALTIME](sql-reference-localtime.md), and [CURRENT\$1ROW\$1TIMESTAMP](sql-reference-current-row-timestamp.md).

## Example
<a name="sql-reference-current-date-example"></a>

```
+---------------+
| CURRENT_DATE  |
+---------------+
| 2008-08-27    |
+---------------+
```