On 28/06/2007 21:04, Jasbinder Singh Bali wrote:
> How can i convert this result into absolute number of days.
Cast your result to type INTERVAL - something like this:
postgres=# select (current_timestamp - timestamp '2007-05-01')::interval;
interval
----------------------
58 days 21:10:36.748
(1 row)
Of course, you'll need to decide how to handle the part of a day left over.
HTH,
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------