Re: Newcomer's date question

From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/06/16
Message-ID: <8ict1q$19e$1@mailint03.im.hou.compaq.com>#1/1

Run
alter session set nls_date_format='DD-MON-YY HH24:MI:SS'; to see the time component of hiredate DATE field.

And try using

WHERE hiredate between to_date('01-MAY-81 00:00:00', 'DD-MON-YY HH24:MI:SS')

                                     and to_date('09-JUN-81 23:59:59',

'DD-MON-YY HH24:MI:SS')

--
be happy

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
Linda Koch wrote in message <3949F3F0.99DB0504_at_postoffice.pacbell.net>...


>Hello

>

>   Can someone tell me what's wrong in the following command?

>

>                        Thank

>SQL> select * from emp;

>

>    EMPNO ENAME      JOB             MGR HIREDATE        SAL

>COMM    DEPTNO

>--------- ---------- --------- --------- --------- --------- ---------

>---------

>     7369 SMITH      CLERK                7902 17-DEC-80

>800                  20

>     7499 ALLEN      SALESMAN       7698 20-FEB-81      1600

>300        30

>     7521 WARD       SALESMAN       7698 22-FEB-81      1250

>500        30

>     7566 JONES      MANAGER         7839 02-APR-81

>2975                  20

>     7654 MARTIN     SALESMAN     7698 28-SEP-81      1250

>1400        30

>     7698 BLAKE      MANAGER        7839 01-MAY-81

>2850                  30

>     7782 CLARK      MANAGER        7839 09-JUN-81

>2450                  10

>     7788 SCOTT      ANALYST          7566 19-APR-87

>3000                  20

>     7839 KING       PRESIDENT                  17-NOV-81

>5000                  10

>     7844 TURNER     SALESMAN     7698   08-SEP-81      1500

>0        30

>     7876 ADAMS      CLERK              7788  23-MAY-87

>1100                  20

>     7900 JAMES      CLERK               7698   03-DEC-81

>950                  30

>     7902 FORD       ANALYST          7566   03-DEC-81

>3000                  20

>     7934 MILLER     CLERK             7782    23-JAN-82

>1300                  10

>

>SQL> select ename, hiredate

>  2     from emp

>  3  where hiredate between '01-MAY-81' and '09-JUN-81';

>

>no rows selected

>

Received on Fri Jun 16 2000 - 00:00:00 CDT