[ADMIN] Date Problem on Imports to 7.2.1

2003-08-28 Thread Geoff Ellis
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

Re: [ADMIN] Date Problem on Imports to 7.2.1 [ SOLVED ]

2003-08-28 Thread Geoff Ellis
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