Received: from home.priority.net (home.priority.net [204.27.108.182]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA39325 for ; Tue, 1 Jun 1999 16:09:47 -0400 (EDT) (envelope-from tpham@mail.priority.net) Received: by home.priority.net with Internet Mail Service (5.5.2232.9) id ; Tue, 1 Jun 1999 15:25:49 -0500 Message-ID: <551413BBBB03D111BF880060B01AACCE0B38F2@home.priority.net> From: "Pham, Thinh" To: "'pgsql-sql@postgresql.org'" Subject: datetime function Date: Tue, 1 Jun 1999 15:25:48 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="iso-8859-1" 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