[Building Sakai] Timezone for events

[Stephen Marquard]

Oracle users may know their events table to be in GMT, but mysql users
know it to be in localtime. Our SAKAI_EVENT records are in GMT+2 which
is our local timezone.
 
So it looks like changing it will inevitably break any external
assumptions for at least one set of institutions.

Regards
Stephen


-- 
Stephen Marquard, Learning Technologies Co-ordinator
Centre for Educational Technology, University of Cape Town
http://www.cet.uct.ac.za
Email / IM (Jabber/XMPP): stephen.marquard at uct.ac.za
Phone: +27-21-650-5037 Cell: +27-83-500-5290 


>>> Matthew Jones <jonespm at umich.edu> 5/23/2011 3:48 PM >>> 
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"
>



 

###
UNIVERSITY OF CAPE TOWN 

This e-mail is subject to the UCT ICT policies and e-mail disclaimer
published on our website at
http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from
+27 21 650 9111. This e-mail is intended only for the person(s) to whom
it is addressed. If the e-mail has reached you in error, please notify
the author. If you are not the intended recipient of the e-mail you may
not use, disclose, copy, redirect or print the content. If this e-mail
is not related to the business of UCT it is sent by the sender in the
sender's individual capacity.

###