Help Requested - turning seconds into minutes and seconds

[AmyJane]

URGENT:
I am doing an Oracle assignment using SQL and PLSQL. The basic topic of the assignment is this guy who wants to store all his cd's/tapes etc in a database. I need to store the length of each song on an album and be able to calculate the total length of the album.
I have therefore stored song lengths as seconds, e.g a song which is 7 minutes, 23 seconds long has been stored as 443 seconds. However, how can I use sql in Oracle to be able to transform this back to minutes and seconds (as number of seconds would not be that useful to the user, they'd want to know how long the cd is in minutes and seconds). PLEASE HELP ME IF YOU CAN.

 

[karluk]

The number of minutes and seconds in 447 seconds is

select trunc(447/60), mod(447,60) from dual

 

[cardy]

Try this
SELECT TO_CHAR ( TO_DATE ( <seconds> , 'SSSSS' ) , 'MI:SS' ) FROM ...

For example
SELECT TO_CHAR ( TO_DATE ( 443 , 'SSSSS' ) , 'MI:SS' ) FROM DUAL;

TO_CH
-----
07:23