Oracle EXTRACT with Timezone
Oracle EXTRACT with Timezone is a SQL function in the Oracle Specific category. Oracle: EXTRACT gets a single date/time field. Can extract timezone fields from TIMESTAMP WITH TIME ZONE. The syntax is EXTRACT(YEAR FROM date_expression). It accepts YEAR FROM date_expression. It returns extracted date/time fields. A typical example: SELECT EXTRACT(YEAR FROM SYSDATE) AS year, EXTRACT(MONTH FROM SYSDATE) AS month, EXTRACT(DAY FROM SYSDATE) AS day, EXTRACT(HOUR FROM SYSTIMESTAMP) AS hour, EXTRACT(MINUTE FROM SYSTIMESTAMP) AS minute, EXTRACT(TIMEZONE_HOUR FROM SYSTIMESTAMP) AS tz_hour, EXTRACT(TIMEZONE_MINUTE FROM SYSTIMESTAMP) AS tz_minute, EXTRACT(TIMEZONE_REGION FROM SYSTIMESTAMP) AS tz_region FROM DUAL; -- Group by year/month: SELECT EXTRACT(YEAR FROM hire_date) AS hire_year, COUNT(*) FROM employees GROUP BY EXTRACT(YEAR FROM hire_date) ORDER BY hire_year; A close relative is SEQUENCE (Oracle), which oracle: generates sequential numbers. Independent of tables. Accessed via NEXTVAL and CURRVAL. A close relative is ROWNUM / FETCH FIRST, which oracle: ROWNUM assigns sequential numbers to rows. Used for limiting results (pre-12c).