Re: date field query *urgent* thnx

i figured it out myself:

this is how:

SELECT creation_time, to_char(creation_time, 'HH24MISS') FROM TABLE_CASE
where to_char(creation_time, 'HH24MISS') > '200000' or to_char(creation_time, 'HH24MISS') < '083000' /

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. Received on Fri Sep 08 2000 - 14:02:13 CDT