[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] date format problem
From:       Bill Barnes <bbarnes () operamail ! com>
Date:       2000-04-28 12:39:56
[Download RAW message or body]

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
------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]