pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPrinting time stamp
2+ messages / 2 participants
[nested] [flat]
* Printing time stamp
@ 2021-09-23 11:47 Firthouse banu <penguinsfairy@gmail.com>
2021-10-07 18:31 ` Re: Printing time stamp Bruce Momjian <bruce@momjian.us>
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-09-23 11:47 Printing time stamp Firthouse banu <penguinsfairy@gmail.com>
@ 2021-10-07 18:31 ` Bruce Momjian <bruce@momjian.us>
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