date format problem - Mailing list pgsql-general

From Bill Barnes
Subject date format problem
Date
Msg-id 3910452E@operamail.com
Whole thread Raw
List pgsql-general
Hello List:

Using 6.5.3 on SuSE 6.4.

Built a table with a date field as type 'datetime'.

I try to copy a text file to the table and get a 'bad date format'
Dates in the text file may be null, but are in the form 1997-12-15.
Have tried several of the date field types with the same result.
The copy executes properly if I redefine the date field to varchar.

Thanks for your help.
Bill Barnes

------------------------------------------------------------
This e-mail has been sent to  you  courtesy of OperaMail,  a
free  web-based  service  from  Opera  Software,  makers  of
the award-winning Web Browser - http://www.operasoftware.com
------------------------------------------------------------


pgsql-general by date:

Previous
From: Maarten Boekhold
Date:
Subject: Re: advice on indexing email
Next
From: frank
Date:
Subject: plperl.so ?