date time function - Mailing list pgsql-general

From Jasbinder Singh Bali
Subject date time function
Date
Msg-id a47902760706281304x1333ee7cnf5fbf01eadbd447a@mail.gmail.com
Whole thread Raw
Responses Re: date time function  (Raymond O'Donnell <rod@iol.ie>)
Re: date time function  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Hi,

I have a timestamp field in my talbe.
I need to check its difference in days with the current date.

field name is time_stamp and I did it as follows:

select age(timestamp '2000-06-28 15:39:47.272045 ')

it gives me something like

6 years 11 mons 29 days 08:20:12.727955

How can i convert this result into absolute number of days.

thanks,

~Jas

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: i need a rad/ide open source for work with postgresql
Next
From: Raymond O'Donnell
Date:
Subject: Re: date time function