[Libreoffice-bugs] [Bug 104918] LibreOffice SQL parser chokes on Firebird's DATEDIFF syntax, making use impossible in normal (non-direct SQL) queries

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Mar 28 08:14:27 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=104918

--- Comment #20 from Gerhard Schaber <gerhard.schaber at gmx.at> ---
For now, this is a workaround, at least to get a result as number of days, if
that helps anyone:
SELECT "ID", ("EndDate"-"StartDate") "DDIFF" FROM "Table3"

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190328/b1a9e9f0/attachment.html>


More information about the Libreoffice-bugs mailing list