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>
