Re: Oracle Beginner Help

On 15 Jan 2006 21:26:14 -0800, stevenplewis_at_gmail.com wrote:

>I'm trying to display data for employees that have the job as a clerk
>and where hired before 1981. I write the following query
>
>
>select ename from emp where hiredate > ('01-JAN-81') and job = 'clerk';
>
>however it doesn't work. Any suggestions

Apart from the remarks by Michel Cadot:
You need to verify whether the hiredates are really in the 20th century.
I have observed when using the default format mask dd-mon-yy, Oracle not supplying the full date in their installation script, they ended up in the 21st century.

--
Sybrand Bakker, Senior Oracle DBA