Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: date field query *urgent* thnx
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.
Received on Fri Sep 08 2000 - 14:00:56 CDT