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

Home -> Community -> Usenet -> c.d.o.misc -> Re: dates

Re: dates

From: Thomas Bierhance <Bierhance_at_orbital-computer.de>
Date: Wed, 02 Jun 1999 21:36:14 +0200
Message-ID: <375587AE.1F33C742@orbital-computer.de> 





> select * from table where initial_date < '01-Jan-99' and final_date >


> '01-Jan-99';


>





try the to_date function: to_date ('01-Jan-99', 'dd-mon-yy'

Received on Wed Jun 02 1999 - 14:36:14 CDT












Original text of this message













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