postgresql7.1 select exp_id, exp_expense, to_char(exp_date,'MM-DD-YYYY') as exp_date, exp_amount, exp_exported from expenses where community_id =:community_id $orderby_clause