Just using the HSQLDB embedded. On Thu, Aug 25, 2016 at 1:00 PM, Bruce Hohl <bruceh...@gmail.com> wrote:
> What type of database is used - HSQLDB embedded, HSQLDB, MySQL, > PostgreSQL, etc? > > On Thu, Aug 25, 2016 at 11:54 AM, Don Parris <parri...@gmail.com> wrote: > >> Hi all, >> >> I need to do some time calculations in LO Base queries - seems fairly >> straightfoward, but I can't seem to find any good info on how this is >> done. >> >> I am calculating hours worked in a day (could span midnight, but that is >> not normally the case). In a certain app similar to Base, I can do: >> (([day_end]-[day_start])-([lunch_end]-[lunch_start])) >> >> In LO Base, the query fails on a wrong data type failure. I am using the >> Date/Time data type (time stamp). Can anyone point me to good information >> on how to perform this calculation in Base? >> >> >> Many thanks in advance! >> Don >> -- >> D.C. Parris, FMP, Linux+, ESL Certificate >> Minister, Security/FM Coordinator, Free Software Advocate >> http://dcparris.net/ <https://www.xing.com/profile/Don_Parris> >> <http://www.linkedin.com/in/dcparris> >> GPG Key ID: F5E179BE >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns >> ubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot be >> deleted >> > > -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ <https://www.xing.com/profile/Don_Parris> <http://www.linkedin.com/in/dcparris> GPG Key ID: F5E179BE -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted