Hi,
Is there any built-in function/add-on module available in PostgreSQL, that
converts a given "timestamp"/"timestamptz" value into its relative distance
from CURRENT_TIMESTAMP? For example, relative distance as today, yesterday,
5 minutes ago, 1 week ago, etc.
Regards,
Gnanam
--
Sent via p
Have you looked into the date time functions already ?
http://www.postgresql.org/docs/9.0/static/functions-datetime.html
Amitabh Kant
On Thu, Aug 4, 2011 at 1:24 PM, Gnanakumar wrote:
> Hi,
>
> Is there any built-in function/add-on module available in PostgreSQL, that
> converts a given "time
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 its
Consider: SELECT (NOW() - '1-Aug-2011')::text || ' ago.' user_string;
yields: "3 days 18:59:24.781174 ago."
From: gna...@zoniac.com
To: amitabhk...@gmail.com
CC: pgsql-sql@postgresql.org
Subject: Re: [SQL] Calculating relative time/distance from CURRENT_TIMESTAMP
Date: Thu, 4 Aug 2011 17:12:51 +
On Thu, Aug 4, 2011 at 4:42 AM, Gnanakumar 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 he
