Re: [libreoffice-users] Calculating the difference between two time values by means of SQL

2021-03-08 Thread Markus Elfring
> You are looking for the function DATEDIFF(string, datetime1, datetime2) Thanks for your information. I got distracted by the key word “DATE” while I was looking for the support of an other time unit. An SQL statement like the following can fit to my application needs. SELECT "day", "start", "s

[libreoffice-users] Calculating the difference between two time values by means of SQL

2021-03-04 Thread Markus Elfring
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, t