cast(<timestamp> as date)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.40.0b✓ 2008R2+✓ 8.3+⊘ 11gR1 - 21ca✓ 5.0+✓ 5.1+✓ 9.7+✓ 2.0+
  1. See “Caution: Oracle Database” above
  2. Use date(<timestamp>) instead