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

Home -> Community -> Mailing Lists -> Oracle-L -> [Q] ORACLE date select problem?

[Q] ORACLE date select problem?

From: L <leed_at_chele.cais.net>
Date: Fri, 13 Oct 2000 10:28:58 -0400 (EDT)
Message-Id: <10648.119181@fatcity.com> 





On ORACLE 7.3.4 database, I tried to select date less than "31-DEC-96".
the following statement does NOT work correctly:



   select account_id, datestamp from table1
   where to_char(datestamp,'DD-MON-YY') < '31-DEC-96';




It still print date like '21_JAN-98'.  



Anyone can give me a hint?
Received on Fri Oct 13 2000 - 09:28:58 CDT












Original text of this message













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