Forum OpenACS Q&A: Response to Payment Service Contract available

Posted by Hamilton Chua on
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 :

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.