Re: HELP with SQL codes

Wow, Deana,

That worked perfectly.!! Thank you !
What's 'RR' ??? That's not covered in any of the Oracle documents I have. *puzzle*

Arthur

On Mon, 11 Sep 2000 12:04:34 +0200, deana strbevski <deana.strbevski_at_ina.hr> wrote:

>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 - 23:25:47 CDT