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: | LPEDKCPEDPFGIJPCKDIBEEAHCAAA.mark@theleistners.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
from
an ancient business system. It stores the ship date as 0000-00-00 for items
that
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
0000-00-00,
but that also does not seem to work. The data file goes something like this:
order number;order date;ship date;
000000000001;2001-01-01;0000-00-00;
000000000002;2001-01-01;2001-02-01;
...
If any more info is needed please ask, I am not really sure what all is
needed. Any
help is definetly appriciated.
Thanks,
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Lorentsen | 2001-08-24 06:38:43 | Re: integrity and inherit |
Previous Message | Murray Hobbs | 2001-08-23 20:46:16 | Re: protected ON DELETE CASCADE |