datetime function - Mailing list pgsql-sql

From Pham, Thinh
Subject datetime function
Date
Msg-id 551413BBBB03D111BF880060B01AACCE0B38F2@home.priority.net
Whole thread Raw
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [ADMIN] Re: [SQL] Data recovery
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Column name's length