Re: Comparing dates in DDL

On Friday, January 4, 2019, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:

> On Fri, 4 Jan 2019, David G. Johnston wrote:
>
> I wondered about this since NULL can be missing, unknown, or otherwise
>>> defined. Are there benefits to allowing an empty value in that column
>>> when
>>> checking that it's later than the start date rather than explicitly
>>> setting
>>> a default date after the start date?
>>>
>>>
>>> I don’t understand the question...
>>
>
> David,
>
> Understandable. :-)
>
> Perhaps this is more clear: is there a difference between not specifying
> a
> default end_date value and specifying NULL as the default end_date value?
>
>
No. If no default is available and a value for the field is not provided
the stored value will be null; a default of null is thus also redundant
specification.

David J.