Re: Printing time stamp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx>        https://momjian.us
  EDB                                      https://enterprisedb.com

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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux