postgresql - Converting time datatype to xxhxxmxxs -


i wonder if there function in postgres can convert values stored 00:00:00 more human friendly format: 3h 5m ?

you can use to_char function:

select to_char(cast('05:03:00' time), 'hh24h mim sss'); 

this produce

05h 03m 00s 

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -