Search Postgresql Archives
date time function
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]