[Koha-bugs] [Bug 27573] Use of NOW() in SQL should be avoided

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573

--- Comment #5 from David Cook <dcook at prosentient.com.au> ---
(In reply to Martin Renvoize from comment #4)
> That's actually what allot of bug 24850 is about.. rather than converting to
> UTC however, it converts to 'local server' (as set in the config) time to
> whatever time (with offset or $timezone attached) timezone and back again.
> 

Actually, Ere corrects my thinking about timestamps and UTC at
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27463#c10. I think my
brain was stuck in PostgreSQL mode. 

> I'd love some input on that one.. it was a pain to write and thus far I
> don't think the reviewers have really got the point.. but you've just
> succinctly stated the exact point in your above comment.

I'll take another look.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.