Postgres Pro
Downloads
Home   >   mailing lists

valid NULL DATE value - Mailing list pgsql-general

From Tony Grant
Subject valid NULL DATE value
Date
Msg-id 998648786.1380.74.camel@tonux
Whole thread Raw
In response to resin-cmp, apache1.3.20, ultradev4, and postgresql7.0 problems  (tomasz konefal <twkonefal@yahoo.ca>)
Responses Re: valid NULL DATE value
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Denis Gasparin
Date:
Subject: Re:
Next
From: "Len Morgan"
Date:
Subject: Re: valid NULL DATE value