Re: Date question

From: Veera Prasad <vprasad_at_olf.com>
Date: Tue, 20 Jun 2000 11:36:00 -0400
Message-Id: <10534.109859@fatcity.com>

Try this way ..
VPRASAD: PRECY>select * from test_table;

NO DT

--------- --------------------
        1 14-jun-2000 11:32:48
        1 15-jun-2000 11:33:04
        1 16-jun-2000 11:33:10
        1 17-jun-2000 11:33:16
        1 18-jun-2000 11:33:21
        1 19-jun-2000 11:33:26
        1 20-jun-2000 11:33:31
        1 21-jun-2000 11:33:38

8 rows selected.

VPRASAD: PRECY>select * from test_Table where dt between to_Date(sysdate-7) and to_Date(sysdate);

NO DT

--------- --------------------
        1 14-jun-2000 11:32:48
        1 15-jun-2000 11:33:04
        1 16-jun-2000 11:33:10
        1 17-jun-2000 11:33:16
        1 18-jun-2000 11:33:21
        1 19-jun-2000 11:33:26
        1 20-jun-2000 11:33:31

7 rows selected.

Veera

Kader Ben wrote:

> Good morning friends,
> Please how can I code a select query that return
> results of one week. For example between to day and
> last week.
>
> TIA
>
> Ben
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Kader Ben
> INET: kaderb_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 20 2000 - 10:36:00 CDT