Index: openacs-4/packages/acs-lang/tcl/localization-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/localization-procs-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-lang/tcl/localization-procs-oracle.xql	9 Mar 2002 02:00:02 -0000	1.2
+++ openacs-4/packages/acs-lang/tcl/localization-procs-oracle.xql	11 Aug 2003 16:18:11 -0000	1.3
@@ -25,4 +25,18 @@
 </fullquery>
 
  
+<fullquery name="lc_time_tz_convert.convert">
+      <querytext>
+      
+        begin
+            :1 := to_char(
+                          timezone.utc_to_local(timezone.get_id(:to), 
+                                                timezone.local_to_utc(timezone.get_id(:from), to_date(:time_value, 'YYYY-MM-DD HH24:MI:SS'))
+                                                ), 'YYYY-MM-DD HH24:MI:SS');
+        end;
+	
+      </querytext>
+</fullquery>
+
+ 
 </queryset>