A temporary solution would be to reformat "o.confirmed_date" to not include the +08 in the following select
db_1row order_select "
select o.order_state, o.creditcard_id, o.confirmed_date, o.cs_comments,
o.shipping_method, o.shipping_address, o.in_basket_date,
o.authorized_date, o.shipping_charged, o.voided_by, o.voided_date,
o.reason_for_void, u.user_id, u.first_names, u.last_name, c.billing_address
from ec_orders o, cc_users u, ec_creditcards
where order_id=:order_id
and o.user_id = u.user_id(+)
and o.creditcard_id = c.creditcard_id(+)"
Your thoughts,
