<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - LibreOffice SQL parser chokes on Firebird's DATEDIFF syntax, making use impossible in normal (non-direct SQL) queries" href="https://bugs.documentfoundation.org/show_bug.cgi?id=104918#c16">Comment # 16</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - LibreOffice SQL parser chokes on Firebird's DATEDIFF syntax, making use impossible in normal (non-direct SQL) queries" href="https://bugs.documentfoundation.org/show_bug.cgi?id=104918">bug 104918</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>(In reply to robert from <a href="show_bug.cgi?id=104918#c0">comment #0</a>) > Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=129934" name="attach_129934" title="Open the query "Datediff". Changing of data impossible. Works only with direct SQL.">attachment 129934</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=129934&action=edit" title="Open the query "Datediff". Changing of data impossible. Works only with direct SQL.">[details]</a> > Open the query "Datediff". Changing of data impossible. Works only with > direct SQL. > > Open the attached Firebird-database. > Start the query "Datediff". > It shows a datediff between two dates. There couldn't be changed data in > this query, because datediff runs only with direct SQL. > > With internal HSQLDB datediff runs in the GUI. You could change data, add > new rows ... > Using Libo6.1Alpha0 latest build (fc5d185bdb0f27bc6014d47338740f741ac05d21) Downloaded the original bug report attachment (ODB from 2016-12-25) This (datediff in querys) is working now as expected and the result set is editable in the GUI. So, close this as working?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>