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,cat
This was over looked.
3.5.1. Date/Time Input
Date and time input is accepted in almost any reasonable format, including
ISO 8601, SQL-compatible, traditional PostgreSQL, and others. For some
formats, ordering of month and day in date input can be ambiguous and there
is support for specifying the e