[Building Sakai] Incorrect dates in Grade Log

Wed Dec 22 08:05:28 PST 2010

Bryan,

I notice that all of the dates are with about four hours of Midnight and 
was wondering what your time zone is.  Is it possible that dates are 
stored in Greenwich Mean Time but are displayed in your local time zone?
---------------------------------------------------------------------------
Matt Mize, Systems Administrator
 - Pay no attention to the man in the back office....
Matt.Mize at notes.udayton.edu
(937) 229-1024

UDit Department, University of Dayton
300 College Park, Dayton, OH, 45469-1302

From:   Bryan Bakotich <bakotibj at plu.edu>
To:     sakai-dev at collab.sakaiproject.org
Date:   12/21/2010 06:19 PM
Subject:        [Building Sakai] Incorrect dates in Grade Log
Sent by:        sakai-dev-bounces at collab.sakaiproject.org

Hi all,

It has been brought to my attention that sometimes the dates displayed in 
the Grade Log are incorrect. Here is a concrete example of what I'm 
looking at:

The DATE_GRADED value for 3 entries in the GB_GRADING_EVENT_T are:
2010-12-14 22:56:01
2010-12-16 17:13:02
2010-12-18 21:50:18

The dates that get displayed to the user in the Grade Log are:
12/15/10
12/17/10
12/19/10

Does anyone know why the dates displayed are all 1 day off from the dates 
that are stored in the database? Thanks for any help!

We are using MySQL 5.1 and Sakai 2.6.x revision 69729

-Bryan

-- 
Bryan Bakotich
Open Source Implementation Specialist
Digital Media Center, Information & Technology Services
Pacific Lutheran University
Tacoma, WA 98447-0013
Phone: 253-536-5021_______________________________________________
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/20101222/6641591c/attachment.html 