Postgres Pro
Downloads
Home   >   mailing lists

Calculating relative time/distance from CURRENT_TIMESTAMP - Mailing list pgsql-sql

From Gnanakumar
Subject Calculating relative time/distance from CURRENT_TIMESTAMP
Date
Msg-id 009301cc527b$c48690b0$4d93b210$@com
Whole thread Raw
Responses Re: Calculating relative time/distance from CURRENT_TIMESTAMP  (Amitabh Kant <amitabhkant@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Raj Mathur (राज माथुर)"
Date:
Subject: Re: Generic design: char vs varchar primary keys
Next
From: Amitabh Kant
Date:
Subject: Re: Calculating relative time/distance from CURRENT_TIMESTAMP