Re: HINT: Perhaps you need a different "datestyle" setting - postgresql

> On 28 Dec 2014, at 12:06, Arup Rakshit  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.