Index: openacs.org-dev/packages/calendar/tcl/calendar-outlook-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/calendar/tcl/calendar-outlook-procs-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs.org-dev/packages/calendar/tcl/calendar-outlook-procs-oracle.xql	31 Jul 2002 16:31:04 -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.org-dev/packages/calendar/tcl/calendar-outlook-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/calendar/tcl/calendar-outlook-procs-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs.org-dev/packages/calendar/tcl/calendar-outlook-procs-postgresql.xql	31 Jul 2002 16:31:04 -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>
Index: openacs.org-dev/packages/forums/www/message-post-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/message-post-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs.org-dev/packages/forums/www/message-post-oracle.xql	31 Jul 2002 16:31:16 -0000	1.1
@@ -0,0 +1,12 @@
+<?xml version="1.0"?>
+<queryset>
+    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+    <fullquery name="messages_select">
+        <querytext>
+          select to_char(sysdate, 'Mon DD YYYY HH24:MI:SS') 
+          from dual
+        </querytext>
+    </fullquery>
+
+</queryset>
Index: openacs.org-dev/packages/forums/www/message-post-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/message-post-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs.org-dev/packages/forums/www/message-post-postgresql.xql	31 Jul 2002 16:31:16 -0000	1.1
@@ -0,0 +1,12 @@
+<?xml version="1.0"?>
+<queryset>
+
+    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+    <fullquery name="select_date">
+        <querytext>
+          select to_char(current_timestamp, 'Mon DD YYYY HH24:MI:SS') 
+        </querytext>
+    </fullquery>
+
+</queryset>