Re: [BUGS] date format problem

2002-01-31 Thread Thomas Lockhart
> Could you please tell me how to set DateStyle? or where can I get the > instruction about it? In the reference page docs on your machine or at: http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-set.html I'm not sure I agree with every nuance of the recommendations for SET DATES

Re: [BUGS] date format problem

2002-01-31 Thread Annie Bai
>"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. Could you pl

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.

[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