Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: HELP with SQL codes

Re: HELP with SQL codes

From: <steveee_ca_at_my-deja.com>
Date: Tue, 12 Sep 2000 12:31:47 GMT
Message-ID: <8pl7nj$8sc$1@nnrp1.deja.com>

*laughing* Go team Deana!!
Arthur, RR is a date format that allows you to deal with dates spanning two centuries..I remember seeing a SMALL bit on it in the Oracle Education book for their SQL course. It compares the year you're in now (e.g. '00') with the date you're entering and decides if the year should be an earlier or later century (like 1949 vs 2049)..that's the only place I've seen it tho'.. Regards,
S

In article <39bdb027.2449443_at_news.iinet.net.au>,   mechhunter_at_rocketmail.com (Puppet Master) wrote:
> 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
> >> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 07:31:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US