Oracle and PostgreSQL:
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'
| SCRIPT:
Oracle and PostgreSQL: 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' |
| Oracle:
|
| PostgreSQL:
|
| MYSQL :
|