Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: date field query *urgent* thnx

Re: date field query *urgent* thnx

From: <tandym_at_hotmail.com>
Date: Fri, 08 Sep 2000 19:00:56 GMT
Message-ID: <8pbd0p$cc0$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US