Timestamp vs. Interval and formatting.... - Mailing list pgsql-novice

Hello,

I've been building an application to catalog my CD collection, and have
been merrily adding the track lengths to a field of type "interval".
This seemed to make the most sense if I wanted to do math on them  (ie.
totals) later on.  Everything was working well until I realized that
tracks over 24 minutes were being returned as "1 day HH:MM".  What is
the easiest way to limit the field to MM:SS?

I noticed that the "to_char" function for intervals is deprecated.
Is timestamp a better choice for this field after all?

Thanks,
Dan J.

_________________
Visit Eva, Anne, and Dan at: http://www.thenormalfamily.net.