Index: openacs-4/packages/calendar/calendar.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/calendar.info,v
diff -u -N -r1.12 -r1.13
--- openacs-4/packages/calendar/calendar.info	22 Jul 2002 21:46:19 -0000	1.12
+++ openacs-4/packages/calendar/calendar.info	26 Jul 2002 03:20:28 -0000	1.13
@@ -54,6 +54,8 @@
             <file type="query_file" db_type="oracle" path="tcl/calendar-display-procs-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="tcl/calendar-display-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/calendar-display-procs.tcl"/>
+            <file type="query_file" db_type="oracle" path="tcl/calendar-outlook-procs-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="tcl/calendar-outlook-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/calendar-outlook-procs.tcl"/>
             <file type="query_file" path="tcl/calendar-outlook-procs.xql"/>
             <file type="query_file" db_type="oracle" path="tcl/calendar-procs-oracle.xql"/>
Index: openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/cal-item-2-procs-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql	22 Jul 2002 21:46:19 -0000	1.2
+++ openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql	26 Jul 2002 03:20:28 -0000	1.3
@@ -15,6 +15,9 @@
          to_char(start_date, 'YYYY-MM-DD HH:MI:SS') as start_date,
          to_char(start_date, 'MM/DD/YYYY') as pretty_short_start_date,
          to_char(end_date, 'HH:MIpm') as end_time,
+         end_date as end_date,
+         to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as full_start_date,
+         to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as full_end_date,
          coalesce(a.name, e.name) as name,
          coalesce(e.description, a.description) as description,
          recurrence_id,
@@ -49,6 +52,9 @@
          to_char(start_date, 'YYYY-MM-DD HH:MI:SS') as start_date,
          to_char(start_date, 'MM/DD/YYYY') as pretty_short_start_date,
          to_char(end_date, 'HH:MIpm') as end_time,
+         end_date as end_date,
+         to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as full_start_date,
+         to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as full_end_date,
          coalesce(a.name, e.name) as name,
          coalesce(e.description, a.description) as description,
          recurrence_id,
Index: openacs-4/packages/calendar/tcl/calendar-outlook-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-outlook-procs-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/tcl/calendar-outlook-procs-oracle.xql	26 Jul 2002 03:20:28 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+<queryset>
+<rdbms><type>oracle</type><version>8.1.6</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.local_to_utc(tz_id, to_date(:timestamp,:format)) as utc_time
+from timezones where tz= :server_tz)
+where tz= :user_tz
+</querytext>
+</fullquery>
+ 
+</queryset>
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 -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/tcl/calendar-outlook-procs-postgresql.xql	26 Jul 2002 03:20:28 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+<queryset>
+<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>
+</fullquery>
+ 
+</queryset>