Gestriges Datum

ID293
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangBigQuery
PlGroupDatum, Zeit
PlItemTitleGestriges Datum
CodeSELECT
CURRENT_TIMESTAMP() AS today_timestamp
, DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY) AS yesterday_as_date
Result Example
today_timestamp yesterday_as_date
2024-02-07 13:40:37.903 2024-02-06