Postgres Pro
Downloads
Home   >   mailing lists

Re: Date / Time Data Type - Mailing list pgsql-novice

From Tom Lane
Subject Re: Date / Time Data Type
Date
Msg-id 21666.1107198124@sss.pgh.pa.us
Whole thread Raw
In response to Date / Time Data Type  ("Van Ingen, Lane" <lvaningen@ESNCC.com>)
List pgsql-novice
Tree view 
"Van Ingen, Lane" <lvaningen@ESNCC.com> writes:
>  updatedTime timestamp NOT NULL default '0000-00-00 00:00:00',  <------   rejected

Instead of using a blatantly invalid timestamp value to mean "no data",
why don't you use NULL?

            regards, tom lane

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: Date / Time Data Type
Next
From: "Van Ingen, Lane"
Date:
Subject: Re: Date / Time Data Type