Have you looked into the date time functions already ?<br /><br /><a
href="http://www.postgresql.org/docs/9.0/static/functions-datetime.html">http://www.postgresql.org/docs/9.0/static/functions-datetime.html</a><br
/><br/><br />Amitabh Kant<br /><br /><div class="gmail_quote">On Thu, Aug 4, 2011 at 1:24 PM, Gnanakumar <span
dir="ltr"><<ahref="mailto:gnanam@zoniac.com">gnanam@zoniac.com</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> Hi,<br /><br /> Is there any
built-infunction/add-on module available in PostgreSQL, that<br /> converts a given "timestamp"/"timestamptz" value
intoits relative distance<br /> from CURRENT_TIMESTAMP? For example, relative distance as today, yesterday,<br /> 5
minutesago, 1 week ago, etc.<br /><br /> Regards,<br /> Gnanam<br /><font color="#888888"><br /><br /><br /> --<br />
Sentvia pgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br /> To make
changesto your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br />