Index: openacs-4/packages/calendar/tcl/calendar-outlook-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-outlook-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/calendar/tcl/calendar-outlook-procs-postgresql.xql	26 Jul 2002 03:20:28 -0000	1.1
+++ openacs-4/packages/calendar/tcl/calendar-outlook-procs-postgresql.xql	17 May 2003 10:20:50 -0000	1.2
@@ -3,13 +3,13 @@
 <rdbms><type>postgresql</type><version>7.1.2</version></rdbms>
 
 <fullquery name="calendar::outlook::adjust_timezone.adjust_timezone">
-<querytext>
-select to_char(timezone__utc_to_local(tz_id, utc_time), :format)
-from timezones,
-(select timezone__convert_to_utc(tz_id, :timestamp) as utc_time
-from timezones where tz= :server_tz) foo
-where tz= :user_tz
-</querytext>
+  <querytext>
+
+    select to_char(server.utc_time - timezone__get_offset(timezone__get_id(:user_tz), server.utc_time), :format)
+    from (select timezone__convert_to_utc(tz_id, :timestamp) as utc_time
+          from timezones where tz= :server_tz) server;
+
+  </querytext>
 </fullquery>
  
 </queryset>