I got it to work but I modifed more than just the query with the confirmed date. I had to do a to_char(date_in_question, 'YYYY-MM-DD HH24:MI:SS') on the dates that caused the error.
The following needed to be modified :
confirmed_date
inserted_date
in_basket_date
I wreckon that this is a temporary fix. We may need to modify ec_formatted_date to handle dates from Postgres - specially if it is used a lot around in ecommerce.
