cast(<timestamp> as time)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.39.0a✓ 2008R2+✓ 8.3+⚠ 12cR2 - 21c⊘ 11gR1 - 12cR1✓ 5.0+✓ 5.1+✓ 9.7+✓ 2.0+
  1. Use time(<timestamp>) instead