Search Postgresql Archives

Re: Comparing dates in DDL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Comparing dates in DDL
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Fri, 4 Jan 2019 09:21:52 -0800 (PST)
In-reply-to: <CA+FnnTwVws6QCUAn4P6tHVkNCpddq9M7OOLN3B+27ZL80TCihg@mail.gmail.com>
References: <alpine.LNX.2.20.1901040851090.29312@salmo.appl-ecosys.com> <CA+FnnTwVws6QCUAn4P6tHVkNCpddq9M7OOLN3B+27ZL80TCihg@mail.gmail.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Comparing dates in DDL
  - From: Rich Shepard
- Re: Comparing dates in DDL
  - From: Igor Korot

Prev by Date: Re: Comparing dates in DDL
Next by Date: Re: Comparing dates in DDL
Previous by thread: Re: Comparing dates in DDL
Next by thread: Re: Comparing dates in DDL
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux