We have some date problems when importing data into the PSQL system. The
following example shows it happening:
Source file = spec.csv
2,1,08/06/99,29/07/99,1,1,A,'R' CONDITION,C,MA,,O,,,,,,,,,,WS000
When imported into Postgres, the data is shown as:
mss_live=# select id,cdate,mdate,code,type,category from spec_header limit 1
;
id | cdate | mdate | code | type
| category
----+------------------------+------------------------+---------------+-----
-+----------
2 | 1999-08-06 00:00:00+01 | 1999-07-29 00:00:00+01 | 'R' CONDITION | C
| MA
(1 row)
The data was imported with "copy table from 'path/to/file' delimiters ','
with '' as null.
As you can see, 08/06/99 (8th June 1999) has been converted to 1999-08-06
(6th August 1999), and 29/07/99 (29th July 1999) has been converted
correctly!
Is there a flag or setting within the database that will allow us to import
the date correctly?
thanks in anticipation..
Geoff Ellis
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
