extract(… from <interval>)

BigQueryDb2 (LUW)DuckDBH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite2007200920112013201520172019202120232025✓ 8.4 - 18a✓ 8.3a✓ 11gR1 - 23.26.0⚠ 1.4.198 - 2.4.240⚠ 1.0.0 - 1.4.0⚠ 2.0⊘ 2.0
  1. Returns approximate numeric type