Index: openacs-4/packages/survey/www/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/index-oracle.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/survey/www/index-oracle.xql 16 Sep 2002 00:00:23 -0000 1.1 +++ openacs-4/packages/survey/www/index-oracle.xql 23 Nov 2002 05:18:14 -0000 1.2 @@ -1,12 +1,12 @@ - +oracle8.1.6 select s.survey_id, s.name, s.editable_p, s.single_response_p, - sr.response_id, sr.creation_date + sr.response_id, to_char(sr.creation_date,'Month FMDD, YYYY') as creation_date from surveys s ,(select survey_id, response_id, creation_date from survey_responses_latest where initial_user_id = :user_id) sr