Calculating with the time

From: "Katka a Daniel Dunajsky" <daniel_katka(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Calculating with the time
Date: 2003-05-30 18:04:05
Message-ID: Law12-F35awhftgLeCR0002781b@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello All,

I am looking for an advice how to do calculation with the time. I do have a
column with datatype 'timestamp with time zone'. The value is '2003-03-22
07:53:56-07' for instance. I would like to select it from the table with
result of '07:59:59' '07:53:56', so the query should return '00:06:03'.

Thank you for your time.

DanielD

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chad Thompson 2003-05-30 19:01:07 Re: Index scan never executed?
Previous Message C F 2003-05-30 18:01:13 Re: CASE returning multiple values (was SQL Help)