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
Message-ID: 1190839359.3098.11.camel@roadwarrior.maipucinos.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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 ?

Regards,
Diego.

Responses

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