Re: importing dates

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: thefronny(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: importing dates
Date: 2008-08-28 19:06:55
Message-ID: dcc563d10808281206g1c47fab8kb712cc82b53a1bc6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 26, 2008 at 2:24 PM, <thefronny(at)gmail(dot)com> wrote:
> I need to copy some data that includes an date as YYYY/MM/DD. Is there
> a method I can do this and replace the "/" with "-" on the fly in the
> copy command string?

You shouldn't need to. Pgsql should accept yyyy/mm/dd as valid date
format and load it right in.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-08-28 19:09:03 Re: MySQL LAST_INSERT_ID() to Postgres
Previous Message Pavel Stehule 2008-08-28 18:40:37 Re: SQL optimization - WHERE SomeField STARTING WITH ...