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') - +