Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: HELP with SQL codes
you should write ('01/01/1981')
Puppet Master wrote:
> Hi,
> I am playing with TO_DATE format and I am having a difficult
> time with it. Below is a code that I do not know why it is not
> working. It should just be picking up date AFTER 1981 but as you
> can see on the first line, it is picking up date before 1981 as well
> (1980) - What am I doing wrong ?
>
> If I put it was /YY, no rows will be picked up.
>
> SQL> SELECT hiredate
> 2 FROM emp
> 3 WHERE hiredate > TO_DATE('01/01/81', 'DD/MM/YYYY');
>
> HIREDATE
> ---------
> 17-DEC-80
> 20-FEB-81
> 22-FEB-81
> 02-APR-81
> 28-SEP-81
> 01-MAY-81
> 09-JUN-81
> 19-APR-87
> 17-NOV-81
> 08-SEP-81
> 23-MAY-87
> 03-DEC-81
> 03-DEC-81
> 23-JAN-82
>
> 14 rows selected.
>
> Beside that, can I also ask if there IS a code that will let me see
> the result of a TO_DATE is :
> Like with the above syntax, it will be nice for me to see the result
> of the converted the 01/01/81.
>
> Thank you,
>
> Arthur
Received on Mon Sep 11 2000 - 02:04:27 CDT