Index: openacs-4/packages/assessment/www/sessions-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/sessions-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/assessment/www/sessions-postgresql.xql	8 Jan 2005 17:27:22 -0000	1.6
+++ openacs-4/packages/assessment/www/sessions-postgresql.xql	18 Jan 2005 12:42:37 -0000	1.7
@@ -5,7 +5,8 @@
 
 	<fullquery name="sessions_of_assessment">
 		<querytext>
-			SELECT r.item_id as assessment_id,s.session_id, s.completed_datetime, s.percent_score,
+			SELECT r.item_id as assessment_id, s.session_id, s.percent_score,
+			       to_char(s.completed_datetime, :format) as completed_datetime,
 			       p.first_names || ' ' || p.last_name AS subject_name,
 			       r.title AS assessment_name, s.subject_id
 			FROM as_sessions s, cr_revisions r, persons p
@@ -19,7 +20,8 @@
 
 	<fullquery name="sessions_of_assessment_of_subject">
 		<querytext>
-			SELECT r.item_id as assessment_id, s.session_id, s.completed_datetime, s.percent_score,
+			SELECT r.item_id as assessment_id, s.session_id, s.percent_score,
+			       to_char(s.completed_datetime, :format) as completed_datetime,
 			       p.first_names || ' ' || p.last_name AS subject_name,
 			       r.title AS assessment_name, s.subject_id
 			FROM as_sessions s, cr_revisions r, persons p