[BUGS] date format problem

2002-01-30 Thread Yan Bai
Hello all, I am using postgresql 7.1.3. I met a problem when i was loading data from a text file to the tables. The table has the following attributes: Tid, Pid, borrowdate, duedate, returndate all the borrowdate < returndate. And the content of the text file used is as: 8,4,27/8/2000,6/9/2000

Re: [BUGS] date format problem

2002-01-30 Thread Tom Lane
"Yan Bai" <[EMAIL PROTECTED]> 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.