Date / Time Data Type - Mailing list pgsql-novice

From Van Ingen, Lane
Subject Date / Time Data Type
Date
Msg-id A3FF4275060B76459B5C08A64AE330C869EC@twmail.esncc.com
Whole thread Raw
Responses Re: Date / Time Data Type  (Frank Bax <fbax@sympatico.ca>)
Re: Date / Time Data Type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I am converting from another database, where the line below was defined as a 'datetime'
datatype. Am trying to convert that data, and it is telling me that my default date is out of
range, and that I perhaps need to do a datestyle setting.
 
After looking at the docs, and even CAST, I still have not been able to figure out how to
set this up, other than just defining it as aa char(19) field.. Does anyone have any suggestions?
 
CREATE TABLE adns_neighbor_history (
 ifID mediumint(8) unsigned NOT NULL default '0',
 updatedTime timestamp NOT NULL default '0000-00-00 00:00:00',  <------   rejected
 remoteNet char(15) default NULL,
 PRIMARY KEY  (ifID,updatedTime)

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: function returning a row
Next
From: Tomas Eroles i Forner
Date:
Subject: How to learn Postgres?