Re: date field query *urgent* thnx

Okay, but what happens when you have different dates? this only gives between 20 and 08 for one date. What if the entries span multiple dates.

In article <8pbd0p$cc0$1_at_nnrp1.deja.com>,   tandym_at_hotmail.com wrote:
> select * from mytable
> where mydate between
> TO_DATE('24-JUN-1995 20:00:00','DD-MON-RRRR HH24:MM:SS')
> AND TO_DATE('25-JUN-1995 08:30:00','DD-MON-RRRR HH24:MM:SS');
>
> sonya
>
> In article <8pbaeb$91l$1_at_nnrp1.deja.com>,
> hajir_at_my-deja.com wrote:
> > how do i do a query on a datetime field for all entries excluding
 those
> > with a TIME value between 8:00pm and 8:30 am??
> >
> > iow, if there is a list of entries with various create times
 spanning
> > for a date range, how do I get the values in the date range
 excluding
> > those with a TIME element between A and B???
> >
> > thanks a bunch for fast response!!!!!!!!!!
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 08 2000 - 15:39:15 CDT