Forum OpenACS Development: Re: Calendar Appointments over a Server with differente GMT

Hello Dirk

Sorry about my delay.

I run this sql query (I've done an extract from views-postgresql.xql file)

select distinct e.name as name, to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_start_date, to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_end_date from acs_activities a,acs_events e,timespans s,time_intervals t,calendars cals,cal_items ci left join cal_item_types cit on cit.item_type_id = ci.item_type_id where e.timespan_id = s.timespan_id and s.interval_id = t.interval_id and e.activity_id = a.activity_id and ci.cal_item_id= e.event_id and e.event_id=7548;

Result is:
name | ansi_start_date | ansi_end_date
--------------------------+---------------------+---------------------
Revisar Error Calendario | 2005-01-08 11:00:00 | 2005-01-08 12:00:00

event_id 7548 was created ad-hoc, and original time was 17:00 to 18:00, and so appears in list, week, and month view. Problem is only in day view

Also, I think problem is in (HTML DOM: td with class: cal-day-time) because (HTML DOM: td with class: cal-day-event) shows the right hour. Example:

11:00 Revisar Error Calendario (17:00 - 18:00) Personal

Regards
Cesáreo