Howdy, The salient point here is the version of HSQLdb which comes with LibreOffice is rather old and lacking when it comes to date manipulation, but it can be done and hopefully this post over at ASK dot LibreOfffice will help answer you question: https://ask.libreoffice.org/en/question/75480/how-to-do-basic-arithmatic-with-dates-in-libre-base-queries/
best wishes, Drew On Thu, Mar 4, 2021 at 9:04 AM Markus Elfring <markus.elfr...@web.de> wrote: > > Hello, > > Two columns of a table (for the database engine “HyperSQL” within the > application > “LibreOffice Base 7.1.0.3-985.1”) have got the data type “TIME”. > I would like to compute a difference for these fields. > > It seems that the following SQL statement is insufficient so far. > > SELECT ID, t1, t2, t2 - t1 AS duration FROM time_measurements1 > > > I would appreciate your advices. > > Would you like to point further information sources out besides query examples > which work with dates and time stamps? > > Regards, > Markus > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
