Re: LIKE Clause with dates?

select hiredate from emp
where hiredate BETWEEN
 TO_DATE('01-MAR-1999','DD-MON-YYYY')
AND TO_DATE('31-MAR-1999','DD-MON-YYYY'); The only reason for the TO_DATE is to cover the change in century coming up...

And if you want to get tricky....you could add a LAST_DAY to the where clause....

Paul in VT Received on Thu Jun 24 1999 - 09:18:16 CDT