A
A
aaltw2021-07-19 15:24:50
PostgreSQL
aaltw, 2021-07-19 15:24:50

How to change postgres timestamp output format?

There is such a date: 3 days 22:29:00. How to turn it into this: 3 days 22 hours 29 minutes ?

Timespamp without timezone

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vasily Bannikov, 2021-07-19
@vabka

https://www.postgresql.org/docs/current/functions-...
to_char(ts, 'D days HH hours MI minutes')

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question