Re: Date / Time Data Type

OK, will do that. Was trying to avoid program changes, but can't make it work any other way.

A MySQL-ism. Thanks for your help.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Mon 1/31/2005 2:02 PM
To: Van Ingen, Lane
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Date / Time Data Type

"Van Ingen, Lane" <lvaningen(at)ESNCC(dot)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