SQL_EXTRACT1.HTM
Oracle, PostgreSQL, MYSQL

SELECT ename, HIREDATE "HDATE", EXTRACT(YEAR FROM HIREDATE)"YEAR" , EXTRACT(MONTH FROM HIREDATE)"MONTH" , EXTRACT(DAY FROM HIREDATE)"DAY" FROM emp where rownum < 7

Mysql

SELECT ename, HIREDATE "HDATE", EXTRACT(YEAR FROM HIREDATE)"YEAR" , EXTRACT(MONTH FROM HIREDATE)"MONTH" , EXTRACT(DAY FROM HIREDATE)"DAY" FROM emp limit 6

Postgresql

SELECT ename, HIREDATE "HDATE", EXTRACT(YEAR FROM HIREDATE)"YEAR" , EXTRACT(MONTH FROM HIREDATE)"MONTH" , EXTRACT(DAY FROM HIREDATE)"DAY" FROM emp limit 6

Oracle:

PostgreSQL
MySQL