cast(<timestamp> as date)

BigQueryDb2 (LUW)DuckDBH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite20052007200920112013201520172019202120232025⊘ 3.5.7 - 3.51.0b✓ 2008R2 - 2025✓ 8.3 - 18⊘ 11gR1 - 23.26.0a✓ 5.0 - 9.5.0✓ 5.1 - 12.1.2✓ 1.4.192 - 2.4.240✓ 1.0.0 - 1.4.0✓ 9.7 - 12.1.2✓ 2.0
  1. See “Caution: Oracle Database” above
  2. Use date(<timestamp>) instead