Is there any sql92 functions (not really essential) that calculates the
timespan between 2 separate points in time? For example, i want to calculate
the total minutes between 2:30pm and 3:30pm. There's a function like this in
microsoft sql but i can't find it in postgres. Below is how it works in ms:
DATEDIFF(minute, '14:30', '15:30')
I looked at the "timespan" function but it's not the same one that i need.
Thanks,
Thinh