Re: Comparing dates in DDL

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 1/4/19 10:12 AM, Igor Korot wrote:
> 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

Is the end_date always knowable at record insert?

CHECK(end_date is null or start_date <= end_date)