Re: SQL question....

argosy22_at_my-deja.com wrote:

> I always like to specify the year in 4 digits
> as a rule. It was short cuts like this that
> created that little Y2K bug.

Yeah, but isn't that just a patch over the issue? You'll be no better than them when Y10K rolls around the corner...
;-)

>
> Cheers,
> Argosy
>
> In article <38DA933C.B16A1AE7_at_erols.com>,
> VS <slootsky_at_erols.com> wrote:
> >
> > Schema: SCOTT
> > 8.0.5 or 8.1.5 environment
> >
> > WHY THIS GOING ON ?!!!!
> >
> > SQL> select ename, job,hiredate
> > 2 from emp
> > 3 where hiredate between
> > 4 to_date ('20-FEB-81') AND
> > 5 to_date ('01-MAY-81')
> > 6 ORDER BY hiredate
> > 7 /
> >
> > no rows selected
> >
> > SQL> select ename, job,hiredate
> > 2 from emp
> > 3 where hiredate between
> > 4 to_date ('20-FEB-1981', 'DD-MM-YYYY') AND
> > 5 to_date ('01-MAY-1981', 'DD-MM-YYYY')
> > 6 ORDER BY hiredate
> > 7 /
> >
> > ENAME JOB HIREDATE
> > ---------- --------- ---------
> > ALLEN SALESMAN 20-FEB-81
> > WARD SALESMAN 22-FEB-81
> > JONES MANAGER 02-APR-81
> > BLAKE MANAGER 01-MAY-81
> >
> > SQL> spool off
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--

PS: Folks: BEA WebLogic is in S.F., and now has some entry-level positions for
people who want to work with Java and E-Commerce infrastructure products. Send
resumes to joe_at_beasys.com
--------------------------------------------------------------------------------
                    The Weblogic Application Server from BEA
         JavaWorld Editor's Choice Award: Best Web Application Server
  Java Developer's Journal Editor's Choice Award: Best Web Application Server
     Crossroads A-List Award: Rapid Application Development Tools for Java
Intelligent Enterprise RealWare: Best Application Using a Component Architecture
               http://weblogic.beasys.com/press/awards/index.htm