[Building Sakai] Timezone for events

[Matthew Jones]

I would agree. I wouldn't make this change so quickly as there are probably
many local places doing data warehousing and other reporting based on what
this column represents already. I think that making any changes to reflect
localtime could break too much at this point.

Locally I know that we've always known the events table to be in GMT and
written the time conversion into our local data reporting scripts like:

(In Oracle, we also copy our events with local scripts to an archive table)
. . .
select new_time(sakai_event_archive.event_date,'GMT','EDT') as
actual_event_date, eid, sakai_event_archive.event,
sakai_event_archive.ref from sakai_event_archive, sakai_session_archive,
sakai_user_id_map where sakai_event_archive.event_date
between new_time(to_date('09-24-2009 00:00:00','MM-DD-YYYY HH24:MI:SS'),
'EDT', 'GMT') and new_time(to_date('09-24-2009 16:00:00','MM-DD-YYYY
HH24:MI:SS'), 'EDT', 'GMT') and . . .
.
-Matthew

On Mon, May 23, 2011 at 9:14 AM, Seth Theriault <slt at columbia.edu> wrote:

> Nico Coetzee wrote:
>
> > I do not think its a database problem, but I think it has
> > something to do with the
> > org.sakaiproject.time.impl.BasicTimeService.java.  It is set up
> > in init to set up dates according to GMT time, and all tool's
> > uses this but the tools also looks at the local users time zone
> > preferences in My Workspace, Preferences and adjust the time
> > accordingly example calendar.  As far as I can see the
> > ClusterEvenetrackingService and the UsageSessionApdaptor, does
> > not do the adjustment, and takes the local time (which is
> > correct) and then converts it to GMT.
>
> A Jira for this has been logged and action already taken:
>
> http://jira.sakaiproject.org/KNL-734
>
> As I think about this more, I am starting to think that the
> logging of times in GMT is an intentional design choice and
> perhaps we don't want to be mucking with this.
>
> Seth
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110523/3664f9b4/attachment.html