Postgres Pro
Downloads
Home   >   mailing lists

Thread: Printing time stamp

Printing time stamp

From
Firthouse banu
Date:
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 



Thanks in advance.
Firthouse

Re: Printing time stamp

From
Bruce Momjian
Date:
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.