valid NULL DATE value

From: Tony Grant <tony(at)animaproductions(dot)com>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: valid NULL DATE value
Date: 2001-08-24 10:26:26
Message-ID: 998648786.1380.74.camel@tonux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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.

How do I go about importing DATE?

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Len Morgan 2001-08-24 12:31:10 Re: valid NULL DATE value
Previous Message Denis Gasparin 2001-08-24 10:20:37 Re: