HOURS_BETWEEN

Description

HOURS_BETWEEN takes a start datetime and an end datetime and returns the number of hours between them.

You can pass the values positionally or using the named arguments start_date and end_date. HOURS_BETWEEN accepts the same narrowing arguments as DAYS_BETWEEN, except day_length, which would have no meaning in a result that is already counted in hours.

If you need the result in days rather than hours, use DAYS_BETWEEN.

The optional arguments that narrow what counts, and how values without a time are treated, are described under counting elapsed time.

Example

p is Person
HOURS_BETWEEN(p.meeting_start, p.meeting_end)

This returns the duration of the meeting in hours.

Example with named arguments

p is Person
HOURS_BETWEEN(start_date: p.meeting_start, end_date: p.meeting_end)

Info

New in Atfinity 17. A named argument that HOURS_BETWEEN does not know is rejected, where it was previously ignored. day_length is rejected as well, where it was previously accepted and then ignored.