bigfunctions > date_sub_isoyear

date_sub_isoyear

Signature

date_sub_isoyear(date, years)

Description

Returns same day years before (same week number and same day of week)

Examples

EUUSeurope-west1

select bigfunctions.eu.date_sub_isoyear('2023-06-02', 3)

select bigfunctions.us.date_sub_isoyear('2023-06-02', 3)

select bigfunctions.europe_west1.date_sub_isoyear('2023-06-02', 3)

+------------------+
| substracted_date |
+------------------+
| 2020-05-29       |
+------------------+