calculate number of minutes between two dates

[ali_hijazi]

Hello

got in a table 2 fields of type date time

ex:

begin                         end

2014/6/25 3:15:45     2014/6/25 4:33:45

...

I want to calculate the number of minutes between begin and end fields

please advise

[shane_spencer · Accepted solution]

interval( end - begin, 'mm') as Duration,

[satishkurra]

Use IntervalMatch function.

[m_woolf]

(end-begin) * 24 * 60 as minutes;