Convert time interval to units of hours

LabKey Support Forum (Inactive)
Convert time interval to units of hours Matthew Bellew  2015-12-14 15:24
Status: Closed
 
Note that the comment in the LabKey SQL docs refers to the units supported by postgres not the size of the interval result. e.g. (SQL_TSI_DAY, SQL_TSI_HOUR, SQL_TSI_MINUTE)

If you need finer granularity of your results, you could do use timestampdiff(..,..,SQL_TSI_MINUTE) and divide by 60.0