time difference

From: Johann Höchtl <big(dot)john(at)bigfoot(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: time difference
Date: 1999-10-25 12:54:09
Message-ID: 381452F1.BBFF0A26@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello !

I have a table say td with two attributes a and b, both of type time.
All i want to do is to calculate the difference in seconds between this
two time values. The value of b should always be greater then the one of
a.

How can i do this ? Allready tried a lot with all the functions \df
showed me but did´nt got closer....

Help would be highly appriciated !

lG,
John

Browse pgsql-general by date

  From Date Subject
Next Message amy cheng 1999-10-25 13:05:42 current_timestamp and default now()
Previous Message greg 1999-10-25 12:47:25 Re: [GENERAL] Import data from a file