Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group