Re: Q: select with between date/time

Hi

Thanks to all for your help!

ralf

>>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<<

Am 26.08.2001, 04:32:30, schrieb avdbi_at_hotmail.com (Anurag Varma) zum Thema 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 Mon Aug 27 2001 - 14:51:49 CDT