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

Hi,

I am actually trying to copy data from my csv file to DB. But I am getting the
DateStyle error.

I tried different ways to make it workable. But no luck!

prac_db=# copy orders from '/home/arup/postgresql/order.csv' with CSV
DELIMITER ',' HEADER ;
ERROR:  date/time field value out of range: " 19/08//2014"
HINT:  Perhaps you need a different "datestyle" setting.
CONTEXT:  COPY orders, line 2, column delivery_date: " 19/08//2014"
prac_db=# SET datestyle = "ISO";
SET
prac_db=# copy orders from '/home/arup/postgresql/order.csv' with CSV
DELIMITER ',' HEADER ;
ERROR:  date/time field value out of range: " 19/08//2014"
HINT:  Perhaps you need a different "datestyle" setting.
CONTEXT:  COPY orders, line 2, column delivery_date: " 19/08//2014"
prac_db=# SET datestyle = "ISO, IS";
ERROR:  invalid value for parameter "DateStyle": "ISO, IS"
DETAIL:  Unrecognized key word: "is".
prac_db=# SET datestyle = "ISO, IS 7900:2001";
ERROR:  invalid value for parameter "DateStyle": "ISO, IS 7900:2001"
DETAIL:  List syntax is invalid.
prac_db=# SET datestyle = "ISO, BIS IS";
ERROR:  invalid value for parameter "DateStyle": "ISO, BIS IS"
DETAIL:  List syntax is invalid.
prac_db=# SET datestyle = "ISO, BIS IS 7900:2001";
ERROR:  invalid value for parameter "DateStyle": "ISO, BIS IS 7900:2001"
DETAIL:  List syntax is invalid.
prac_db=#

My Data style inside the CSV exactly like -
http://en.wikipedia.org/wiki/Date_and_time_notation_in_India. How to fix this
problem?

--
================
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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general