Re: Is there a way to get just the number of seconds between two timestamps?

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is there a way to get just the number of seconds between two timestamps?
Date: 2009-04-09 07:48:35
Message-ID: dbbf25900904090048uf98533eq6c7f85d4cbd5330@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> What is wrong with EXTRACT?

Nothing, now that I found out about the "epoch" option. I must haev missed that.
I just feared to have to do extracct for each time unit...
Problem solved with extract epoch. :-)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Wright, George 2009-04-09 13:03:09 auto vacuum question
Previous Message A. Kretschmer 2009-04-09 05:13:39 Re: Time-based trigger/procedure