SYSDATE problem

From: Teresa Mah <tmah_at_home.com>
Date: Thu, 19 Nov 1998 16:56:07 -0800
Message-ID: <3654BE27.75A782A0@home.com>

Hi,

I'm trying to create a table, with one of the date attributes having the constraint that the date has to be greater than the current date:

I've defined the table as follows:

SQL> create table mydates (
  2 date1 DATE not null primary key,
  3 date2 DATE CHECK (date2 > SYSDATE),   4 date3 DATE,
  5 date4 DATE);
date2 DATE CHECK (date2 > SYSDATE),

                          *

ERROR at line 3:
ORA-02436: date or system variable wrongly specified in CHECK constraint
Can anyone tell me what's wrong?

Thank you in advance.

Teresa Received on Thu Nov 19 1998 - 18:56:07 CST