> On 28 Dec 2014, at 12:06, Arup Rakshit <aruprakshit@xxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
