Index: openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql,v
diff -u -r1.33 -r1.34
--- openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	17 May 2003 10:39:21 -0000	1.33
+++ openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	13 Aug 2003 13:30:53 -0000	1.34
@@ -49,7 +49,7 @@
                    fs_objects.name,
                    fs_objects.live_revision,
                    fs_objects.type,
-                   to_char(fs_objects.last_modified, 'Month DD YYYY HH24:MI') as last_modified,
+                   to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
                    fs_objects.content_size,
                    fs_objects.url,
                    fs_objects.key,
Index: openacs-4/packages/file-storage/www/file.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/file.adp,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/file-storage/www/file.adp	22 May 2003 14:55:53 -0000	1.12
+++ openacs-4/packages/file-storage/www/file.adp	13 Aug 2003 13:30:53 -0000	1.13
@@ -64,7 +64,7 @@
     <td>@version.author@</td>
     <td align=right>@version.content_size_pretty@</td>
     <td>@version.type@</td>
-    <td>@version.last_modified@</td>
+    <td>@version.last_modified_pretty@</td>
     <td>@version.description@&nbsp;</td>
     <td>
       &nbsp;<if @version.delete_p@ true>
Index: openacs-4/packages/file-storage/www/folder-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/Attic/folder-chunk-oracle.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/file-storage/www/folder-chunk-oracle.xql	7 Jul 2003 12:37:39 -0000	1.6
+++ openacs-4/packages/file-storage/www/folder-chunk-oracle.xql	13 Aug 2003 13:30:53 -0000	1.7
@@ -9,7 +9,7 @@
                    fs_objects.name,
                    fs_objects.live_revision,
                    fs_objects.type,
-                   to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified,
+                   to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
                    fs_objects.content_size,
                    fs_objects.url,
                    content_item.get_path(fs_objects.object_id, :root_folder_id) as file_url,
@@ -38,7 +38,3 @@
         </querytext>
     </fullquery>
 </queryset>
-
-
-
-
Index: openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql	7 Jul 2003 12:37:39 -0000	1.7
+++ openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql	13 Aug 2003 13:30:53 -0000	1.8
@@ -9,7 +9,7 @@
                    fs_objects.name,
                    fs_objects.live_revision,
                    fs_objects.type,
-                   to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified,
+                   to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
                    fs_objects.content_size,
                    fs_objects.url,
                    content_item__get_path(fs_objects.object_id, :root_folder_id) as file_url,
Index: openacs-4/packages/file-storage/www/folder-chunk.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/folder-chunk.adp,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/file-storage/www/folder-chunk.adp	7 Jul 2003 12:37:39 -0000	1.18
+++ openacs-4/packages/file-storage/www/folder-chunk.adp	13 Aug 2003 13:30:53 -0000	1.19
@@ -23,10 +23,10 @@
 	</td>
 	<td>&nbsp;</td>
 	<td align="right">
-	  @contents.content_size@ <if @contents.content_size@ ne 1>#file-storage.items#</if><else>#file-storage.item#</else>
+	  @contents.content_size_pretty@ <if @contents.content_size@ ne 1>#file-storage.items#</if><else>#file-storage.item#</else>
 	</td>
 	<td>@contents.type@</td>
-	<td>@contents.last_modified@</td>
+	<td>@contents.last_modified_pretty@</td>
       </if>
       <else>
 	<if @contents.type@ eq "url">
@@ -51,7 +51,7 @@
 	  </td>
 	  <td>&nbsp;</td>
 	  <td>@contents.type@</td>
-	  <td>@contents.last_modified@</td>
+	  <td>@contents.last_modified_pretty@</td>
 	</if>
 	<else>
 	  <td><a href="@fs_url@download/@contents.file_upload_name@?version_id=@contents.live_revision@"><img src="@fs_url@graphics/file.gif" alt="#file-storage.file#" border="0"></a></td>
@@ -66,9 +66,9 @@
 	  <td>
 	    <small><a href="@fs_url@file?file_id=@contents.object_id@">#file-storage.view_details#</a></small>
 	  </td>
-          <td align="right">@contents.content_size@ byte<if @contents.content_size@ ne 1>s</if></td>
+          <td align="right">@contents.content_size_pretty@ byte<if @contents.content_size@ ne 1>s</if></td>
 	  <td>@contents.type@</td>
-	  <td>@contents.last_modified@</td>
+	  <td>@contents.last_modified_pretty@</td>
 	</else>
       </else>
     </tr>
Index: openacs-4/packages/simple-survey/www/one-respondent-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/www/one-respondent-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/simple-survey/www/one-respondent-postgresql.xql	15 Jun 2001 01:06:39 -0000	1.1
+++ openacs-4/packages/simple-survey/www/one-respondent-postgresql.xql	13 Aug 2003 13:31:46 -0000	1.2
@@ -5,7 +5,7 @@
 
 <fullquery name="response_ids_select">      
       <querytext>
-    select response_id, creation_date, to_char(creation_date, 'DD MONTH YYYY') as pretty_submission_date
+    select response_id, creation_date, to_char(creation_date, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi
     from survsimp_responses, acs_objects
     where survey_id = :survey_id
     and response_id = object_id