Re: HINT: Perhaps you need a different "datestyle" setting - postgresql
От | Alban Hertroys |
---|---|
Тема | Re: HINT: Perhaps you need a different "datestyle" setting - postgresql |
Дата | |
Msg-id | C314FAF5-61D7-4767-B6B9-195431CEDA63@gmail.com обсуждение исходный текст |
Ответ на | Re: HINT: Perhaps you need a different "datestyle" setting - postgresql (Arup Rakshit <aruprakshit@rocketmail.com>) |
Ответы |
Re: HINT: Perhaps you need a different "datestyle" setting - postgresql
|
Список | pgsql-general |
> On 28 Dec 2014, at 12:06, Arup Rakshit <aruprakshit@rocketmail.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 yourorders 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 hoursmakes 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.
В списке pgsql-general по дате отправления: