Re: Q: select with between date/time

In PL/SQL
DECLARE
today4am DATE := TO_DATE(

            to_char(sysdate,'mmddyyyy') || '04:00:00', 'mmddyyyy hh24:mi:ss'); yesterday7pm DATE := today4am - 9/24;

....
SELECT .....
WHERE daDate BETWEEN today4am AND yesterday7pm;

Anurag

Ralf Bender <ralf.bender_at_nexgo.de>
> hello
>
> i want to write a select statement which tells me all rows between
> yesterday 07:00PM and today 04:00AM, BUT i don't know how. i want save
>
> Can someone tell how to write such select?
>
> thx
> ralf
Received on Sat Aug 25 2001 - 21:32:30 CDT