Index: openacs-4/packages/acs-lang/tcl/locale-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/Attic/locale-procs-postgresql.xql,v
diff -u -r1.2.4.1 -r1.2.4.2
--- openacs-4/packages/acs-lang/tcl/locale-procs-postgresql.xql	16 Feb 2003 20:53:36 -0000	1.2.4.1
+++ openacs-4/packages/acs-lang/tcl/locale-procs-postgresql.xql	3 Mar 2003 17:41:57 -0000	1.2.4.2
@@ -6,8 +6,7 @@
 <fullquery name="ad_locale_system_tz_offset.system_offset">      
       <querytext>
       
-	select ( (current_timestamp - timezone__local_to_utc (:system_timezone, current_timestamp)) * 24 )
-	
+	select timezone__get_offset (timezone__get_id(:system_timezone), current_timestamp)
     
       </querytext>
 </fullquery>
Index: openacs-4/packages/acs-lang/tcl/locale-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/locale-procs.tcl,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/acs-lang/tcl/locale-procs.tcl	29 Aug 2001 21:22:49 -0000	1.2
+++ openacs-4/packages/acs-lang/tcl/locale-procs.tcl	3 Mar 2003 17:41:57 -0000	1.2.4.1
@@ -37,10 +37,7 @@
     @return number of hours to subtract from local (Oracle) time to get UTC
 } {
     set system_timezone [ad_locale_get_system_timezone]
-    return [db_string system_offset {
-	select ( (sysdate - timezone.local_to_utc (:system_timezone, sysdate)) * 24 )
-	from dual
-    }]
+    return [db_string system_offset {}]
 }
 
 
Index: openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-display-procs-postgresql.xql,v
diff -u -r1.7.2.1 -r1.7.2.2
--- openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql	2 Mar 2003 22:41:11 -0000	1.7.2.1
+++ openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql	3 Mar 2003 17:42:27 -0000	1.7.2.2
@@ -109,8 +109,8 @@
 and      e.activity_id = a.activity_id
 and      start_date between
          to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
-and     cal_items.cal_item_id= e.event_id
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
+and      cal_items.cal_item_id= e.event_id
 and      e.event_id
 in       (
          select  cal_item_id
@@ -173,7 +173,7 @@
 and      e.activity_id = a.activity_id
 and      start_date between
          to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
 and      e.event_id
 in       (
          select  cal_item_id
Index: openacs-4/packages/calendar/www/cal-dayview-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-dayview-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/calendar/www/cal-dayview-postgresql.xql	23 Sep 2001 14:45:00 -0000	1.1
+++ openacs-4/packages/calendar/www/cal-dayview-postgresql.xql	3 Mar 2003 17:43:03 -0000	1.1.4.1
@@ -20,7 +20,7 @@
 and      e.activity_id = a.activity_id
 and      start_date between
          to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
 and      e.event_id
 in       (
          select  cal_item_id
@@ -49,7 +49,7 @@
 and      e.activity_id = a.activity_id
 and      start_date between
          to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
 and      e.event_id
 in       (
          select  cal_item_id
Index: openacs-4/packages/calendar/www/cal-listview-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-listview-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/calendar/www/cal-listview-postgresql.xql	23 Sep 2001 14:45:00 -0000	1.1
+++ openacs-4/packages/calendar/www/cal-listview-postgresql.xql	3 Mar 2003 17:43:03 -0000	1.1.4.1
@@ -20,7 +20,7 @@
 and      e.activity_id = a.activity_id
 and      start_date between
         to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
 and      e.event_id
 in       (
            select    cal_item_id
@@ -49,7 +49,7 @@
 and      e.activity_id = a.activity_id
 and      start_date between
         to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
 and      e.event_id
 in       (
            select    cal_item_id