Returns today's date — without the time.
CURRENT_DATE
It's written without brackets, like a word. The result type is date, so you add whole days to it: CURRENT_DATE + 7 is a week from now. Like NOW(), the value stays the same for the whole transaction and depends on the session's time zone: for someone it's already tomorrow.
orders
| id | created_at | amount |
|---|---|---|
| 1 | 2026-07-03 10:15:00 | 120.50 |
| 2 | 2026-07-28 18:40:00 | 80.25 |
| 3 | 2026-08-09 09:05:00 | 199.99 |
| 4 | 2026-08-21 14:30:00 | 45.00 |
| 5 | 2026-09-02 11:00:00 | 64.75 |
These tables already exist in the sandbox — the examples below use them. Want to try this in your own database? Copy the SQL.
| today |
|---|
| 2026-09-14 |
Press “Run” to see your date.
| next_week | month_ago |
|---|---|
| 2026-09-21 | 2026-08-14 00:00:00 |
| id | created_at | days_ago |
|---|---|---|
| 1 | 2026-07-03 10:15:00 | 73 |
| 2 | 2026-07-28 18:40:00 | 48 |
| 3 | 2026-08-09 09:05:00 | 36 |
| 4 | 2026-08-21 14:30:00 | 24 |
| 5 | 2026-09-02 11:00:00 | 12 |
The difference between two dates is a whole number of days.
No brackets: CURRENT_DATE() throws syntax error at or near "(".
CURRENT_DATE - INTERVAL '1 month' is no longer a date but a timestamp. If you need a plain date, add ::date.
Compare it with a timestamp column using a range: created_at = CURRENT_DATE only finds moments at exactly midnight. For today — created_at >= CURRENT_DATE AND created_at < CURRENT_DATE + 1.