Skip to main content

YESTERDAY

Returns yesterday date, same as today() - 1.

Syntax​

YESTERDAY()

Return Type​

DATE, returns date in “YYYY-MM-DD” format.

Examples​

SELECT YESTERDAY();
+-------------+
| YESTERDAY() |
+-------------+
| 2021-09-02  |
+-------------+

SELECT TODAY()-1;
+---------------+
| (TODAY() - 1) |
+---------------+
| 2021-09-02    |
+---------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today