Index: openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql,v diff -u -r1.16 -r1.17 --- openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 27 Sep 2007 13:21:22 -0000 1.16 +++ openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 29 Aug 2008 15:13:49 -0000 1.17 @@ -818,8 +818,8 @@ and (p_edit_past_events_p = ''t'' or start_date >= v_one_start_date) LOOP PERFORM time_interval__edit(v_timespan.interval_id, - v_timespan.start_date + (p_start_date - v_one_start_date), - v_timespan.end_date + (p_end_date - v_one_end_date)); + (to_char(v_timespan.start_date,''yyyy-mm-dd'') || '' '' || to_char(p_start_date,''hh24:mi:ss'')) :: timestamptz, + (to_char(v_timespan.end_date,''yyyy-mm-dd'') || '' '' || to_char(p_end_date,''hh24:mi:ss'')) :: timestamptz); END LOOP; return p_event_id;