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.
pgsql-general by date
|Next:||From: Raymond O'Donnell||Date: 2007-06-28 20:13:44|
|Subject: Re: date time function|
|Previous:||From: Raymond O'Donnell||Date: 2007-06-28 18:43:23|
|Subject: Re: [GENERAL] i need a rad/ide open source for work with postgresql|