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: Check constraint question...

Re: Check constraint question...

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Thu, 25 Apr 2002 14:18:20 +0200
Message-ID: <aa8s5u$f5l$1@news.mch.sbs.de> 





Hi,



you can't compare a string to a date, use the following:
ALTER TABLE ACTIVITYTRACKING200205 ADD CONSTRAINT ACTIVITY200205

CHECK (ACTIVITYDATE BETWEEN to_date('01-MAY-02', 'DD-MON-YY')  AND
to_date('31-MAY-02', 'DD-MON-YY'));



Regards


Stephan
Received on Thu Apr 25 2002 - 07:18:20 CDT












Original text of this message













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