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 Steve Crawford
Subject Re: Is there a way to get just the number of seconds between two timestamps?
Date
Msg-id 49DCC20C.9050902@pinpointresearch.com
Whole thread Raw
In response to Is there a way to get just the number of seconds between two timestamps?  (A B <gentosaker@gmail.com>)
List pgsql-novice
Tree view 
A B wrote:
> I want to just get the number of seconds and not have to use extract
> for seconds, minutes, hours, days, months, years, etc.
> Is that possible?
>
>
extract(epoch from your_end_time) - extract(epoch from your_start_time)

Cheers,
Steve

pgsql-novice by date:

Previous
From: A B
Date:
Subject: Is there a way to get just the number of seconds between two timestamps?
Next
From: Michael Lush
Date:
Subject: Re: Is there a way to get just the number of seconds between two timestamps?