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 -> Comparing Date - Problem

Comparing Date - Problem

From: Tom Miskiewicz <miskiewicz2_at_yahoo.com>
Date: Wed, 29 Oct 2003 23:22:55 +0100
Message-ID: <bnpel2$gq1$1@news.gatel.net> 





Hi!



I got stuck with this:



SELECT Request_ID FROM Test WHERE StartDate > TO_DATE('02.10.2003',
'DD.MM.YYYY');


*


ERROR at line 1: ORA-00932: inconsistent datatypes



I also tried a number of other options like TO_NUMBER(TRUNC(TO_DATE...,
TRUNC(TO_DATE etc. Same problem.




Thanks


Tom
Received on Wed Oct 29 2003 - 16:22:55 CST












Original text of this message













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