On Thu, 2005-02-10 at 22:58 -0600, Bruno Wolff III wrote:
> EXTRACT the EPOCH from the difference of the timestamps. This will give
> you the elapsed times in seconds (as a float8 I think).
This is unnecessarily complicated, don't you think? Doesn't it make
sense that there should be a way to get an interval "cast" to only hours
or only minutes or only days?
Instead of an interval *always* being shown as "3 days 4 hours 5
minutes", why can't we get "76 hours" or "4565 minutes"? Isn't there a
function to extract, or cast, or something? And if not, should there be?
Rodolfo J. Paiz <rpaiz(at)simpaticus(dot)com>
In response to
pgsql-novice by date
|Next:||From: Deepblues||Date: 2005-02-14 19:11:19|
|Subject: Question on PL/Perl|
|Previous:||From: Kjetil Haaland||Date: 2005-02-14 09:08:43|
|Subject: Re: function returning a row|