extract(… from <datetime>)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.43.0⊘ 2008R2 - 2022✓ 14 - 16b✓ 8.3 - 13b✓ 11gR1 - 21c⚠ 5.0 - 8.0.34a⚠ 5.1 - 10.11⚠ 9.7 - 11.5.8c⚠ 2.0
  1. No time zone fields. SECOND does not include fractions. Use SECOND_MICROSECOND
  2. Returns approximate numeric type
  3. No time zone fields