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 <[email protected]> wrote: > 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 pgsql-sql mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
