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.