Re: copy command - date

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: novice <user(dot)postgresql(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: copy command - date
Date: 2007-08-13 00:47:55
Message-ID: 12012.1186966075@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

novice <user(dot)postgresql(at)gmail(dot)com> writes:
> I'm having trouble loading the date field. Should I convert it first
> or should I be using a text processor before loading the data in?

> 3665 OK SM 07/07/13 06:09
> 5162 OK SM 07/02/12 06:10
> 3665 OK SM 07/06/19 06:10

What sort of trouble, exactly?

I'm guessing that you might need to set DateStyle to tell Postgres what
the date field ordering is, but without seeing any error messages that's
strictly a guess.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message novice 2007-08-13 01:49:13 Re: copy command - date
Previous Message novice 2007-08-13 00:25:59 copy command - date