[OPEN-ILS-DEV] import_demo question

[Bill Ott]

> psql:insert_holdings.sql:1: ERROR:  date/time field value out of 
> range: "12/13/1993"
> HINT:  Perhaps you need a different "datestyle" setting.
> psql:insert_holdings.sql:2: ERROR:  current transaction is aborted, 
> commands ignored until end of transaction block
> psql:insert_holdings.sql:3: ERROR:  current transaction is aborted, 
> commands ignored until end of transaction block
> ......
>
> So, can you help me figure out how to fix this problem it is having 
> with my create date of 12/13/1993. 

The short answer is, it's expecting an ISO 8601 date.  i.e.  yyyy-mm-dd

If you feel adventuresome, the following *should* reformat all dates in 
the file.  Just in case, it will also create a backup of your original. 
   perl -i.orig -p -e 's/(\d+)(\/)(\d+)(\/)(\d{4})/$5-$1-$3/g' <filename>