Search Postgresql Archives

Re: copy command - date

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



novice <user.postgresql@xxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux