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- > 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 > -- 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
