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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 Bug 27573 depends on bug 27511, which changed state. Bug 27511 Summary: Don't use NOW() in saved sql last run update https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27511 What|Removed |Add

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 --- Comment #6 from David Cook --- (In reply to Martin Renvoize from comment #4) > 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 > succ

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 --- Comment #5 from David Cook --- (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

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 --- Comment #4 from Martin Renvoize --- 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 at

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 --- Comment #3 from David Cook --- (In reply to Martin Renvoize from comment #2) > In conversation with Jonathan I discovered we actually set the timezone on > the database connection handle.. so this isn't the problem I suspected it

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 Martin Renvoize changed: What|Removed |Added Status|NEW |RESOLVED Resoluti

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 David Cook changed: What|Removed |Added CC||dc...@prosentient.com.au --- C

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 Bug 27573 depends on bug 27574, which changed state. Bug 27574 Summary: Don't use NOW() in Koha::Accounts https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27574 What|Removed |Added

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 Martin Renvoize changed: What|Removed |Added Depends on||27574 Referenced Bugs:

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27573 Martin Renvoize changed: What|Removed |Added Depends on||27511 Referenced Bugs: