(Solved) Difference between two times

2 replies [Last post]
Thu, 01 Jan 2015 - 9:22 AM
venoom27
Offline
Last seen: 3 weeks 3 days ago
Title: ★★★
Joined: 23 Nov 2014
Posts: 28
Could someone refer me to documentation or tell me how I could find the difference between two times in a query sql statement?

Example
The hour and minute difference between these two times 22:00 and 23:05

Top
Thu, 01 Jan 2015 - 10:57 AM
#1
eremmel
Offline
Last seen: 5 days 20 hours ago
Title: ★★★★★
Joined: 15 Dec 2011
Posts: 276
HSQLDB 1.6 SQL syntax
It depends highly on your database. But I guess you are using the internal database shipped with Base. This is HSQLDB 1.8. Documentation about SQL can be found here.
n/a
Top
Thu, 01 Jan 2015 - 3:15 PM
#2
venoom27
Offline
Last seen: 3 weeks 3 days ago
Title: ★★★
Joined: 23 Nov 2014
Posts: 28
Thanks so much
Thanks so much
Top

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.