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

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" <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