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)
In response to
pgsql-novice by date
|Next:||From: Michael Lush||Date: 2009-04-08 15:36:38|
|Subject: Re: Is there a way to get just the number of seconds between
|Previous:||From: A B||Date: 2009-04-08 15:14:36|
|Subject: Is there a way to get just the number of seconds between two timestamps?|