Comment 1 for bug 1074195

As an alternative to throwing out the trigger, changing the create_due_date() function, and redoing the due date UI, could we just pull the new time zone info into the trigger instead? Use 'SET LOCAL TIME ZONE XYZ' (substitute a real TZ) in the trigger before we mangle the date, then it would get set to 11:59pm for the library doing the circ, and whatever that happens to be for the server.

We might need to consider in a few places what happens to the date when it comes back out, but if we already see the "wrong" due date now, then the code is already doing the time zone shift on output in at least one place.