How about seconds and then present it as minutes and seconds. eg 4m 22 s.
which would store as 262.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"eglekar" <member22103_at_dbforums.com> wrote in message
news:2366308.1042111916_at_dbforums.com...
>
> I just completed my first class in Oracle and for my final
> project I built
> a music CD database. I have a table called "songs" which has the
> song title
> and the running time (among other fields) and a table called
> "album" which
> links to the "songs" table. What is the best way to define the duration
> of every song?
>
> Thank you for your support.
>
> --
> Posted via http://dbforums.com
Received on Thu Jan 09 2003 - 07:24:42 CST
