Date: Thu, 7 Oct 2021 14:31:09 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Firthouse banu <penguinsfairy@gmail.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Re: Printing time stamp
Message-ID: <20211007183109.GC5476@momjian.us>
References: 
 <CAK_Ha4w=5QGiwNufcABo7NrJ_JxsMVYUCnjphvedcFj4PLYFnA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAK_Ha4w=5QGiwNufcABo7NrJ_JxsMVYUCnjphvedcFj4PLYFnA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20211007183109.GC5476%40momjian.us>
Precedence: bulk

On Thu, Sep 23, 2021 at 05:17:14PM +0530, Firthouse banu wrote:
> Thanks you all for clarifying my doubts so far. 
> 
> Here is another one. 
> 
> Scenario
> 
> How to print time stamp for every 60 seconds like 60 seconds interval between
> given start and end date 

How is this?

	SELECT generate_series('2021-01-01 00:00:00', '2021-01-02 00:00:00', '1 minute'::interval);

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.