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.