Re: valid NULL DATE value

From: "Len Morgan" <len-morgan(at)crcom(dot)net>
To: "Tony Grant" <tony(at)animaproductions(dot)com>, "postgres list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: valid NULL DATE value
Date: 2001-08-24 12:31:10
Message-ID: 002301c12c98$a86f4480$0908a8c0@bstx.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I am importing via pgaccess a text file from another non-postgres
> database and the NULL DATE values are written like 00/00/00.
>
> What I have tried is replacing 00/00/00 by 9/9/1999 and setting the
> style to european and I am getting 'can't parse /9/1999' errors.

Try replacing 00/00/00 with NULL in the text file. If the text file is
organized to be read by the COPY command, then use \N instead.

len morgan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2001-08-24 12:36:26 Re: SELECT FOR UPDATE
Previous Message Tony Grant 2001-08-24 10:26:26 valid NULL DATE value