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: (view raw or whole thread)
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 ? 



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-2015 The PostgreSQL Global Development Group