SQL_TODATE_BETWEEN1

SQL DATE BETWEEN

ORACLE :

select empno,ename, job, hiredate
from emp
where hiredate between to_date('01-01-81', 'DD-MM-RR') AND to_date('01-07-81', 'DD-MM-RR')

PostgreSQL and Oracle

SELECT * FROM EMP WHERE hiredate BETWEEN '01-JAN-81' and '31-JUL-81'

MYSQL

SELECT * FROM EMP WHERE hiredate BETWEEN '1981-01-01' and '1981-07-31'

EMP TABLE

ORACLE:

Oracle (contd.)

PostgreSQL