Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group