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