Re: HELP with SQL codes

ok ! then try this format 'dd/mm/rr'
Deana

Puppet Master wrote:

> I know but I can't.
> The whole exercise is to prompt the user to enter a date in the format
> of dd/mm/yy - thus what they enter will be 01/01/84 or something.
> That is why I am trying to make it convert what is being enter
> into a 4 digit year.
>
> =o)
>
> Arthur
>
> On Mon, 11 Sep 2000 09:04:27 +0200, deana strbevski
> <deana.strbevski_at_ina.hr> wrote:
>
> >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 - 05:04:34 CDT