troubleshooting Question

Postgresql Interval Query

Avatar of mpginsburg
mpginsburg asked on
4 Comments1 Solution5553 ViewsLast Modified:
I am outputting a table that has a user's response with the period of time that has elapsed next to it

John Smith     |   Yes (15 mins ago)
Bob Jones     |    No ( 12 days ago)
Sally Thomas  |   Yes (1 month ago)

I have a table that holds the last updated time, but am having trouble getting the elapsed time.  I know that I can get the interval doing:
SELECT NOW() - last_updated
FROM ...

And I know that I can use the EXTRACT or DATE_PART functions to get the value that I need, but I want it to round to the nearest unit such as seconds, minutes, hours, days, weeks, months, years

I would prefer to not use PHP to do the calculations.  Any thoughts?

Postgresql 8.1.8
PHP 5.2.1

earth man2

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros