[postgresql] How do I convert a postgresql floating point value to a

[shashank025]

time value (HH:MM:SS)? Currently, I have this:

select column_name, elapsed_time_seconds from my_table;

column_name | elapsed_time_seconds

---------------------+---------------

A | 3500.0

B | 456.0

C | 234.0

I would like to see:

column_name | elapsed_time

---------------------+---------------

A | 58:20.00

B | 07:36.00

C | 03:54.00

Is there a defined postgres function that converts a floating point value into a formatted time value: HH:MM:SS ?

[Andrei M]

Try this:

time "00:00:00" + interval elapsed_time_seconds

For example:

select column_name, time "00:00:00" + interval elapsed_time_seconds from my_table

[Panky]

I Think you are getting total Number of seconds But u want to see in Mins:Sec

becz 3500 Seconds = 3500/60=58.33 mins

seems so.

simple

select column_name,To_Char(elapsed_time_seconds/60) from my_table

or

select column_name,Replace(To_Char(Round((elapsed_time_se conds/60),2) ,'.',':') || ':' from my_table

may be it works