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

On Sunday, December 28, 2014 01:24:00 PM you wrote:
>
> > 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.
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 hours makes 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