datestyle question

From: Diego Gil <diego(at)adminsa(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: datestyle question
Date: 2007-09-26 20:42:39
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-general


I have a file to import to postgresql that have an unusual date format.
For example, Jan 20 2007 is 20022007, in DDMMYYYY format, without any
separator. I know that a 20072002 (YYYYMMDD) is ok, but I don't know how
to handle the DDMMYYYY dates.

I tried and tried but I can't import those dates to postgresql.

Any hint, other than editing file ?



Browse pgsql-general by date

  From Date Subject
Next Message Keaton Adams 2007-09-26 20:44:52 Memory usage of COPY command
Previous Message Martijn van Oosterhout 2007-09-26 20:17:00 Re: Autostart PostgreSQL in Ubuntu