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 -N -r1.3 -r1.3.26.1
--- openacs-4/packages/acs-lang/tcl/localization-procs-oracle.xql 11 Aug 2003 16:18:11 -0000 1.3
+++ openacs-4/packages/acs-lang/tcl/localization-procs-oracle.xql 7 Jan 2020 16:03:06 -0000 1.3.26.1
@@ -3,40 +3,40 @@
oracle8.1.6
-
+
-
+
begin
:1 := to_char(timezone.utc_to_local(timezone.get_id(:tz), to_date(:time_value, 'YYYY-MM-DD HH24:MI:SS')), 'YYYY-MM-DD HH24:MI:SS');
end;
-
+
-
-
+
+
-
+
begin
:1 := to_char(timezone.local_to_utc(timezone.get_id(:tz), to_date(:time_value, 'YYYY-MM-DD HH24:MI:SS')), 'YYYY-MM-DD HH24:MI:SS');
end;
-
+
-
+
-
+
begin
:1 := to_char(
- timezone.utc_to_local(timezone.get_id(:to),
+ 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;
-
+
-
+
Index: openacs-4/packages/acs-lang/tcl/localization-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/localization-procs-postgresql.xql,v
diff -u -N -r1.5 -r1.5.26.1
--- openacs-4/packages/acs-lang/tcl/localization-procs-postgresql.xql 11 Aug 2003 16:18:11 -0000 1.5
+++ openacs-4/packages/acs-lang/tcl/localization-procs-postgresql.xql 7 Jan 2020 16:03:06 -0000 1.5.26.1
@@ -3,33 +3,32 @@
postgresql7.1
-
+
select to_char(timezone__convert_to_local(timezone__get_id(:tz), :time_value), 'YYYY-MM-DD HH24:MI:SS')
-
+
-
-
+
+
select to_char(timezone__convert_to_utc(timezone__get_id(:tz), :time_value), 'YYYY-MM-DD HH24:MI:SS')
-
+
-
+
-
- select to_char(
- timezone__convert_to_local(timezone__get_id(:to),
+ select to_char(
+ timezone__convert_to_local(timezone__get_id(:to),
to_char(timezone__convert_to_utc(timezone__get_id(:from), :time_value), 'YYYY-MM-DD HH24:MI:SS')
), 'YYYY-MM-DD HH24:MI:SS')
-
+