Re: [libreoffice-users] Time Calculations in LOBase

What type of database is used - HSQLDB embedded, HSQLDB, MySQL, PostgreSQL,
etc?

On Thu, Aug 25, 2016 at 11:54 AM, Don Parris <parrisdc@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+unsubscribe@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+unsubscribe@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