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

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

pgsql-general by date

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

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