Re: Oracle question

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