Index: openacs-4/packages/assessment/www/asm-admin/assessment-form.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/assessment-form.tcl,v diff -u -r1.9.2.8 -r1.9.2.9 --- openacs-4/packages/assessment/www/asm-admin/assessment-form.tcl 21 Jul 2005 18:28:12 -0000 1.9.2.8 +++ openacs-4/packages/assessment/www/asm-admin/assessment-form.tcl 21 Jul 2005 18:41:48 -0000 1.9.2.9 @@ -36,7 +36,6 @@ set context [list [list index [_ assessment.admin]] $page_title] set package_id [ad_conn package_id] -set sql_format "YYYY-MM-DD HH24:MI:SS" set form_format "[lc_get formbuilder_date_format] [lc_get formbuilder_time_format]" set user_id [ad_conn user_id] Index: openacs-4/packages/assessment/www/asm-admin/assessment-form.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/assessment-form.xql,v diff -u -r1.4.2.1 -r1.4.2.2 --- openacs-4/packages/assessment/www/asm-admin/assessment-form.xql 19 Jul 2005 15:57:12 -0000 1.4.2.1 +++ openacs-4/packages/assessment/www/asm-admin/assessment-form.xql 21 Jul 2005 18:41:48 -0000 1.4.2.2 @@ -8,7 +8,7 @@ a.anonymous_p, a.secure_access_p, a.reuse_responses_p, a.show_item_name_p, random_p, a.entry_page, a.exit_page, a.consent_page, a.return_url, a.number_tries, a.wait_between_tries, a.time_for_response, a.show_feedback, a.section_navigation, - to_char(a.start_time, :sql_format) as start_time, to_char(a.end_time, :sql_format) as end_time + to_char(a.start_time, 'YYYY-MM-DD HH24:MI:SS') as start_time, to_char(a.end_time, 'YYYY-MM-DD HH24:MI:SS') as end_time from as_assessments a, cr_revisions cr, cr_items ci where ci.item_id = :assessment_id and cr.revision_id = ci.latest_revision