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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
