week

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite20052007200920112013201520172019202120238.3 - 18bc5.0 - 9.4.0a5.1 - 12.0.2a11.5.7 - 12.1.2be⚡ 11.5.6de11.1 - 11.5.5d2.0c2.0a
  1. Sunday-based weeks with first Sunday in year
  2. ISO 8601 week date (year’s first Thursday)
  3. Use extract(isoyear) for the corresponding year
  4. Buggy? Jan 1 seems to be always week 1
  5. Buggy! E.g. 2005-01-01 till 2005-01-08 all belong to week 1 (Eight days a week)