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.