Re: Calculating relative time/distance from CURRENT_TIMESTAMP

On Thu, Aug 4, 2011 at 4:42 AM, Gnanakumar <gnanam(at)zoniac(dot)com> wrote:

> Hi Amitabh,****
>
> ** **
>
> Yes, I already took a glance of the Date/Time functions. But what I’m
> expecting is something more meaningful/user-friendly value to be returned
> than from the actual return value of these functions available here. I’m
> just finding out whether this could be solved at query level itself.****
>
> ** **
>
> For example, there is age(timestamp, timestamp) function. If I call like
> this select age(current_timestamp, (current_timestamp - interval '1 day'))it returns
> ****
>
> “1 day”. But what I’m expecting to be returned from the function is
> something more meaningful/user-friendly to the end users. In this case, I
> wanted it to return “yesterday”, similarly today, 15 minutes ago, 1 week
> ago, etc.
>

If you really want a flexible function for doing this, I suspect you could
replicate the functionality of jquery's 'timeago' module in a stored proc
relatively easily. http://timeago.yarp.com/ It is MIT licensed, so you can
copy the logic without restriction. It makes reference to being derivative
of a ruby project, so you could probably grab that code and convert it to
ruby-pg very easily.