Index: openacs-4/packages/acs-lang/www/admin/set-system-timezone-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/set-system-timezone-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-lang/www/admin/set-system-timezone-postgresql.xql	3 Dec 2002 17:27:23 -0000	1.1
+++ openacs-4/packages/acs-lang/www/admin/set-system-timezone-postgresql.xql	8 Aug 2003 12:21:28 -0000	1.2
@@ -4,9 +4,17 @@
  
 <fullquery name="sysdate">
     <querytext>
-	select to_char(current_time, 'YYYY-MM-DD HH24:MI:SS')
+	select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS')
     </querytext>
 </fullquery>
+
+  <fullquery name="sysdate_utc">      
+    <querytext>
+      select to_char(timezone__convert_to_utc(timezone__get_id(:system_timezone), to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS')), 'YYYY-MM-DD HH24:MI:SS')
+    </querytext>
+  </fullquery>
+ 
+
 	        
 </queryset>
-	                            
\ No newline at end of file
+