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
Post a Comment