Re: date format problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Yan Bai" <annie_job(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: date format problem
Date: 2002-01-31 05:11:07
Message-ID: 347.1012453867@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Yan Bai" <annie_job(at)hotmail(dot)com> writes:
> I met a problem when i was loading data from a text file to the tables.

You need to set DateStyle to tell the system the format of your date
data before you load the file. Evidently the default (US style) is
not what you are expecting.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter V. Cooper 2002-01-31 15:37:27 New to Postgresql - Backend timeout /JDBC
Previous Message Yan Bai 2002-01-31 04:49:11 date format problem