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
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 +
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
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,
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
