[go: up one dir, main page]
More Web Proxy on the site http://driver.im/

week

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite20052007200920112013201520172019202120238.3 - 17bc5.0 - 9.1a5.1 - 11.6a11.5.7 - 11.5.9be⚡ 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)