Re: date field query *urgent* thnx

select * from <table>
where to_char(datetime_field,'HH24/MI') < '20/00' and to_char(datetime_field,'HH24/MI') > '08:30'

Reinier.

<hajir_at_my-deja.com> wrote in message news:8pbaeb$91l$1_at_nnrp1.deja.com...
> 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.
Received on Mon Sep 11 2000 - 05:10:49 CDT