Forum OpenACS Q&A: Re: 4.6.3 ecommerce belches request-error on ugly_date

It sounds like we have 3 choices for fixing this problem.

1. Have each query for each page format the date in the sql.
2. Put a regsub into ec_formatted_date procs and use those consistently in the tcl code.
3. Changing the data model to timestamp(0) without time zone.

I think I agree with Bart. #1 may be the "Right" thing to do but we stand a huge chance of introducing random bugs and its too much effort for the value.

#3 does seem like a better solution then #2.

Thanks Bart.

Caroline