YESTERDAY
Returns yesterday date, same as today() - 1
.
Syntax
YESTERDAY()
Return Type
DATE
, returns date in “YYYY-MM-DD” format.
Examples
SELECT YESTERDAY(), TODAY()-1;
┌───────────────────────────┐
│ yesterday() │ today() - 1 │
├─────────────┼─────────────┤
│ 2024-05-21 │ 2024-05-21 │
└───────────────────────────┘