Happens all the time in various ways Jennifer. Once upon a time (last week) I spent about five minutes scratching my head as to why my reports were "an hour off" before I realized that my laptop for some reason was in the wrong time zone and when I copied and pasted from SQL into Excel Excel was kindly "adjusting" the times for me. Recording time zone information along with time stamps may seem excessive but I wouldn't be surprised to find consortiums (maybe in Canada?) that cross time zones and find it necessary.
I still have no idea how my laptop ended up in that time zone .... On Thu, Feb 26, 2015 at 4:42 PM, Walz, Jennifer <jlw...@asbury.edu> wrote: > Mike, > > > > Oy! That sounds crazy. But I will check on that… > > > > Thanks! > > > > Jennifer > > > > *From:* Open-ils-general [mailto: > open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Mike > Rylander > *Sent:* Thursday, February 26, 2015 4:39 PM > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] Due date conundrum - time due is weird > > > > Jennifer, > > > > Evergreen pushes the due time to 11:59pm on transactions that have > day-granular circ durations. So, it sounds like you've got a timezone > mismatch somewhere. Likely, your database server (or the database > iteself), or the app server if separate, thinks it lives in UTC instead > your correct timezone. > > > > HTH, > > > > > -- > > Mike Rylander > > | President > > | Equinox Software, Inc. / The Open Source Experts > > | phone: 1-877-OPEN-ILS (673-6457) > > | email: mi...@esilibrary.com > > | web: http://www.esilibrary.com > > > > > > On Thu, Feb 26, 2015 at 4:05 PM, Walz, Jennifer <jlw...@asbury.edu> wrote: > > All – > > > > I have a conundrum with our due date / times. When we currently check > out an item to a student, it give them the normal three week due DATE, but > adds a time which is 7:59pm. Where is it getting the time from?? We > are open until 11:59 each day of the week (m-f) and a due TIME of 7:59 is > really odd. I have checked our Org hours and they are set correctly for > our branch. Our due dates are set for the circ rules for 21 days. WHERE > is it getting the TIME from?? > > > > If someone can enlighten me about some setting that I have missed, I > would be very grateful. Currently when students turn in an item on the day > it was due but AFTER the time it was due, they are charged a fine. We > would like to fix that! > > > > Thanks! > > Jennifer > > > > -------------------------------------------------- > Jennifer Walz, MLS – ILS befuddled > Kinlaw Library > Asbury University > 1 Macklem Drive, Wilmore, KY 40390 > 859-858-3511 ext. 2269 > jlw...@asbury.edu > > > > > -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
