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@sss.pgh.pa.us] 
	Sent: Mon 1/31/2005 2:02 PM 
	To: Van Ingen, Lane 
	Cc: pgsql-novice@postgresql.org 
	Subject: Re: [NOVICE] Date / Time Data Type 
	
	

	"Van Ingen, Lane"  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