Re: SQL question....

From: <argosy22_at_my-deja.com>
Date: 2000/03/23
Message-ID: <8beans$152$1@nnrp1.deja.com>#1/1

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.

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. Received on Thu Mar 23 2000 - 00:00:00 CST