Обсуждение: Printing time stamp

Поиск
Список
Период
Сортировка

Printing time stamp

От
Firthouse banu
Дата:
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

От
Bruce Momjian
Дата:
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.