how to convert a time interval to seconds?

From: Chansup Byun <Chansup(dot)Byun(at)Sun(dot)COM>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to convert a time interval to seconds?
Date: 2006-09-12 14:39:25
Message-ID: 4506C69D.9030501@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I searched how to convert a time interval to seconds but failed to find
an example.

I want to convert the following wait_time column into seconds. How can I
do that? The datatype for the wait_time is time without timezone.

job_number | task_number | submission_time | wait_time
------------+-------------+---------------------+-----------
56 | 0 | 2006-04-13 08:47:53 | 00:01:28
55 | 0 | 2006-04-13 08:47:51 | 00:01:21
58 | 0 | 2006-04-13 08:47:54 | 00:01:28
60 | 0 | 2006-04-13 08:47:55 | 00:01:27

Thanks,

- Chansup

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2006-09-12 14:55:03 Re: how to convert a time interval to seconds?
Previous Message Sree Narayana 2006-09-12 14:33:22 Re: Sorry.Problme in my pg_restore command.