How to change postgres timestamp output format?

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

Reply

Answer the question

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')

Similar questions

W

wawa2018-06-22 17:38:14

How to speed up pagination in Django? 1Reply

D

dylan552021-09-22 08:05:24

How to separate a mail domain and group it? 1Reply

S

Sergey2013-08-11 17:30:56

Tell me where to dig on the client-server application 3Reply

A

AE422020-06-28 14:16:24

Hanging postgres queries? 1Reply

S

s0rr0w2013-08-13 23:59:28

Who met with the problem of slow work of WS under Apache in linux version 1C 8.2? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question