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

Home -> Community -> Usenet -> c.d.o.server -> Re: I have a problem with the oracle date comparison --plz help

Re: I have a problem with the oracle date comparison --plz help

From: ora_guy <blairv_at_gmail.com>
Date: 20 Sep 2005 14:13:37 -0700
Message-ID: <1127250817.029337.18960@g47g2000cwa.googlegroups.com> 





when you compare dates you generally use the 'between' function.  i.e.
where order_tm between TO_DATE('19-SEP-05' ,'dd-mon-yy') and
to_date('21-SEP-05','dd-mon-yy').  Play around with the dates till you
get what you want.
Received on Tue Sep 20 2005 - 16:13:37 CDT












Original text of this message













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