Re: HINT: Perhaps you need a different "datestyle" setting - postgresql - Mailing list pgsql-general

From Arup Rakshit
Subject Re: HINT: Perhaps you need a different "datestyle" setting - postgresql
Date
Msg-id 202839649.79u3Qy9osq@linux-wzza.site
Whole thread Raw
In response to Re: HINT: Perhaps you need a different "datestyle" setting - postgresql  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
On Sunday, December 28, 2014 01:24:00 PM you wrote:
>
> > 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. 
Data came that way.
>
> 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. 
No it is not a range. It is 9 hours 25 minutes( morning). :)
> Alban Hertroys


--
================
Regards,
Arup Rakshit
================
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as
possible,you are, by definition, not smart enough to debug it. 

--Brian Kernighan


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: HINT: Perhaps you need a different "datestyle" setting - postgresql
Next
From: Melvin Davidson
Date:
Subject: Re: Rollback on include error in psql