Re: [postgis-users] shp2pgsql - bad date formats

2011-04-14 Thread Sandro Santilli
On Thu, Apr 14, 2011 at 12:56:33PM -0500, Jeff Dege wrote: > ERROR: date/time field value out of range: "0" > HINT: Perhaps you need a different "datestyle" setting. > > What I need is for these features to be inserted with NULL date fields, > instead of '0'. You may try to: 1) prepare the ta

[postgis-users] shp2pgsql - bad date formats

2011-04-14 Thread Jeff Dege
I'm trying to load a shapefile into a PostGIS database, using shp2pgsql and psql. It's failing because a couple of the sql insert statements have date fields containing '0'. ERROR: date/time field value out of range: "0" HINT: Perhaps you need a different "datestyle" setting. What I need is