[OPEN-ILS-GENERAL] Due date conundrum - time due is weird

[Rogan Hamby]

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 <jlwalz at asbury.edu> wrote:

>  Mike,
>
>
>
> Oy!   That sounds crazy.  But I will check on that…
>
>
>
> Thanks!
>
>
>
> Jennifer
>
>
>
> *From:* Open-ils-general [mailto:
> open-ils-general-bounces at 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:  miker at esilibrary.com
>
>  | web:  http://www.esilibrary.com
>
>
>
>
>
> On Thu, Feb 26, 2015 at 4:05 PM, Walz, Jennifer <jlwalz at 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
> jlwalz at 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150226/ab25360a/attachment.html>