postgresql7.1 select s.survey_id, s.name, s.editable_p, s.single_response_p, sr.response_id, to_char(sr.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date, s.package_id from surveys s, survey_responses_latest sr, dotlrn_communities com where s.enabled_p='t' and s.survey_id = sr.survey_id and sr.initial_user_id= :oneUser and com.community_id= :oneCom and apm_package__parent_id(s.package_id) = com.package_id order by upper(s.name) select s.survey_id, s.name, s.editable_p, s.single_response_p, sr.response_id, to_char(sr.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date, s.package_id from surveys s, survey_responses_latest sr where s.enabled_p='t' and s.survey_id = sr.survey_id and sr.initial_user_id= :oneUser order by upper(s.name) select s.survey_id, s.name, s.editable_p, s.single_response_p, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date, s.package_id from surveys s, dotlrn_communities com, acs_objects o where s.enabled_p='t' and o.object_id=s.survey_id and com.community_id= :oneCom and apm_package__parent_id(s.package_id) = com.package_id order by upper(s.name) select s.survey_id, s.name, s.editable_p, s.single_response_p, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date, s.package_id from surveys s, acs_objects o where s.enabled_p='t' and o.object_id=s.survey_id order by upper(s.name) select first_names, last_name, email, to_char(creation_date, 'YYYY-MM-DD HH24:MI:SS') as registration_date, to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit from cc_users where user_id = :oneUser select f.community_key as key, f.community_id as id, f.pretty_name as pretty_name, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date from dotlrn_communities_full f, acs_objects o where f.community_id= :oneCom and o.object_id= f.community_id