Hi, Rich, On Fri, Jan 4, 2019 at 10:53 AM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote: > > 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. start_date.day() + 1? Thank you. > > TIA, > > Rich >
