From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
---|---|
To: | Arup Rakshit <aruprakshit(at)rocketmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: HINT: Perhaps you need a different "datestyle" setting - postgresql |
Date: | 2014-12-28 12:24:00 |
Message-ID: | C314FAF5-61D7-4767-B6B9-195431CEDA63@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 28 Dec 2014, at 12:06, Arup Rakshit <aruprakshit(at)rocketmail(dot)com> wrote:
>
> Now I have another problem:
>
> prac_db=# SET datestyle = "SQL, DMY";
> SET
> prac_db=# copy orders from '/home/arup/postgresql/order.csv' with CSV
> DELIMITER ',' HEADER ;
> ERROR: time zone displacement out of range: " 9-25 AM"
> CONTEXT: COPY orders, line 2, column delivery_time: " 9-25 AM"
> prac_db=#
>
> =======
> ERROR: time zone displacement out of range: " 9-25 AM"
> =======
>
> How to fix this ?
Shouldn’t that read "9:25 AM”, with a colon instead of a dash? If that’s the case, fix your data before feeding it to your orders table.
If not, what is “9-25 AM" supposed to mean? A timezone offset (which is what +/- means in a time) of more than +/-12 hours makes no sense on this planet. Neither does a time-range, especially not with the AM addition.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2014-12-28 14:43:08 | Re: Rollback on include error in psql |
Previous Message | Pavel Stehule | 2014-12-28 12:20:55 | Re: HINT: Perhaps you need a different "datestyle" setting - postgresql |