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

Date Type

From: "Mark D(dot) Leistner" <mark(at)theleistners(dot)org>
To: "Postgres - Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Date Type
Date: 2001-08-24 01:14:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Can anyone help me with the Date type?  I can't seem to insert null values
into a
field I created of type Date.  I am trying to import from a flat file made
an ancient business system.  It stores the ship date as 0000-00-00 for items
have not shipped.  This imports fine into mysql and mssql, but does not
import into
postgresql.  I have also tried just putting a blank field when these is a
but that also does not seem to work. The data file goes something like this:

order number;order date;ship date;

If any more info is needed please ask, I am not really sure what all is
needed.  Any
help is definetly appriciated.


pgsql-novice by date

Next:From: Bo LorentsenDate: 2001-08-24 06:38:43
Subject: Re: integrity and inherit
Previous:From: Murray HobbsDate: 2001-08-23 20:46:16
Subject: Re: protected ON DELETE CASCADE

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