Comparing dates in DDL

[Rich Shepard]

  I have a projects table that includes these two columns:

start_date date DEFAULT CURRENT_DATE,
end_date date
        CONSTRAINT valid_start_date
        CHECK (start_date <= end_date),

  1. Do I need a DEFAULT value for the end_date?
  2. If so, please suggest a value for it.

TIA,

Rich