Re: Comparing dates in DDL

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Comparing dates in DDL
Date: 2019-01-04 17:21:52
Message-ID: alpine.LNX.2.20.1901040920570.29312@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 4 Jan 2019, Igor Korot wrote:

>> 1. Do I need a DEFAULT value for the end_date?
>> 2. If so, please suggest a value for it.
>
> start_date.day() + 1?

Thanks, Igor. I did not pick up this syntax when I looked at data types
and their DDL usage.

Regards,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2019-01-04 17:24:12 Re: Comparing dates in DDL
Previous Message Rob Sargent 2019-01-04 17:18:51 Re: Comparing dates in DDL