Skip site navigation (1) Skip section navigation (2)

Re: Date / Time Data Type

From: "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Date / Time Data Type
Date: 2005-01-31 19:12:44
Message-ID: A3FF4275060B76459B5C08A64AE330C869ED@twmail.esncc.com (view raw or flat)
Thread:
Lists: 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(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
	

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-01-31 19:13:58
Subject: Last ID Problem
Previous:From: Terry Lee TuckerDate: 2005-01-31 19:09:38
Subject: Re: How to learn Postgres?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group