pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Printing time stamp
2+ messages / 2 participants
[nested] [flat]

* Printing time stamp
@ 2021-09-23 11:47  Firthouse banu <penguinsfairy@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Firthouse banu @ 2021-09-23 11:47 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Printing time stamp
@ 2021-10-07 18:31  Bruce Momjian <bruce@momjian.us>
  parent: Firthouse banu <penguinsfairy@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2021-10-07 18:31 UTC (permalink / raw)
  To: Firthouse banu <penguinsfairy@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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.






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2021-10-07 18:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-09-23 11:47 Printing time stamp Firthouse banu <penguinsfairy@gmail.com>
2021-10-07 18:31 ` Bruce Momjian <bruce@momjian.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox