Index: openacs-4/packages/acs-templating/tcl/date-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/date-procs.tcl,v diff -u -N -r1.34 -r1.35 --- openacs-4/packages/acs-templating/tcl/date-procs.tcl 13 Jan 2005 13:56:00 -0000 1.34 +++ openacs-4/packages/acs-templating/tcl/date-procs.tcl 12 Mar 2005 21:39:59 -0000 1.35 @@ -289,7 +289,14 @@ } set pad "00" } - return "to_date('$value', '$format')" + + # DRB: We need to differentiate between date and timestamp, for PG, at least, + # and since Oracle supports to_timestamp() we'll just do it for both DBs. + if { [llength $date] <= 3 } { + return "to_date('$value', '$format')" + } else { + return "to_timestamp('$value', '$format')" + } } ansi { # LARS: Empty date results in NULL value