date format problem

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,28/8/2000
33,48,12/11/2000,22/11/2000,21/11/2000
...

But After loading, the records in the table is as:
8 4 2000-08-27 2000-06-09 2000-08-28
33 4 2000-12-11 2000-11-22 2000-11-21
...

Say, 27/8 could be recognized as 08-27, while 6/9 was recognized as 06-09
So, some of the records have borrowdate > returndate, which is very weird.

Annie

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.