extract(… from <datetime>)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.39.0⊘ 2008R2 - 2019✓ 14+d✓ 8.3 - 13d✓ 11gR1+⚠ 5.6 - 8.0.30bc⚠ 5.0 - 5.5ab⚠ 5.3 - 10.9.2bc⚠ 5.1 - 5.2ab⚠ 9.7 - 11.5.7a⚠ 2.0ab
  1. No time zone fields
  2. SECOND does not include fractions
  3. SECOND does not include fractions. Use SECOND_MICROSECOND
  4. Returns approximate numeric type