1 of 1

YESTERDAY

This page describes the YESTERDAY function in Lenses SQL.

YESTERDAY()

Returns the current date time minus 1 day.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT YESTERDAY() 
FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "YESTERDAY": "2023-11-28T18:57:13.27Z"
  }
}

This page describes the YESTERDAY function in Lenses SQL.

YESTERDAY()

Returns the current date time minus 1 day.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT YESTERDAY() 
FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "YESTERDAY": "2023-11-28T18:57:13.27Z"
  }
}