# DATE

```
DATE(days)
```

Builds a local date value from a long or int value. This function can also be used with no parameters to return the current ISO date.

Available in:

| Processors | SQL Studio |
| ---------- | ---------- |
| ✓          | ✓          |

*Sample code:*

```sql
USE `kafka`;
SELECT DATE() 
FROM sea-vessel-position-reports
LIMIT 1;
```

*Output:*

```json
{
  "value": {
    "DATE": "2023-11-29T00:00:00Z"
  }
}
```