isoweek

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite201520172019202120232.0b2.0a
  1. ISO 8601 week date (year’s first Thursday)
  2. Use extract(isoyear) for the corresponding year