Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a way to get just the number of seconds between two timestamps? - Mailing list pgsql-novice

From A B
Subject Re: Is there a way to get just the number of seconds between two timestamps?
Date
Msg-id dbbf25900904090048uf98533eq6c7f85d4cbd5330@mail.gmail.com
Whole thread Raw
In response to Re: Is there a way to get just the number of seconds between two timestamps?  (Michael Lush <mjlush@ebi.ac.uk>)
List pgsql-novice
Tree view 
> 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. :-)

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Time-based trigger/procedure
Next
From: "Wright, George"
Date:
Subject: auto vacuum question