Objectives : Example of using to_char in Oracle/Postgresql, and DATE_FORMAT FUNCTION in MySQL

Oracle : to_char

  • RR_MM_DD:

    select EMPNO,ENAME, to_char(HIREDATE,'RR-DD-MM') from emp WHERE ROWNUM < 5 ORDER BY ENAME

  • MM-DD-RR

    Select EMPNO,ENAME, to_char(HIREDATE,'MM-DD-RR') from emp WHERE ROWNUM < 5 ORDER BY ENAME
 
Postgrsq1

 Select EMPNO,ENAME, to_char(HIREDATE,'MM/DD/YY') from emp limit 4

PostgreSQL :

Select EMPNO,ENAME, to_char(HIREDATE,'YY/MM/DD') from emp limit 4

 
Mysql:

Select EMPNO,ENAME, DATE_FORMAT(hiredate,'%m-%d-%y') as qdate from emp limit 4