"Bad date external representation"

From: Lynna Landstreet <lynna(at)gallery44(dot)org>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: "Bad date external representation"
Date: 2003-06-18 23:37:05
Message-ID: BB166FE1.3F5%lynna@gallery44.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi folks,

I just got the following error when attempting to use the \copy command in
psql to import data from a text file into a PostgreSQL table:

ERROR: copy: line 1, Bad date external representation '9/19/2002'

I tried setting the datestyle to SQL and US using "set datestyle", but it
didn't help. Anyone have any idea what the problem might be?

Thanks,

Lynna
--
Resource Centre Database Coordinator
Gallery 44
www.gallery44.org

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ron Mayer 2003-06-19 01:10:58 Re: Limiting processor power on queries
Previous Message Tom Lane 2003-06-18 21:36:32 Re: How to NOT perform an insert