Home » SQL & PL/SQL » SQL & PL/SQL » handling the length of musical pieces
handling the length of musical pieces [message #872] Sun, 10 March 2002 17:55 Go to next message
jim
Messages: 74
Registered: July 2000
Member
Hi everyone,
I'm designing a datebase system for a recording studio which i need to keep records of the length of every musical pieces. Shall I use date as the datatype? and how can i perform calculations on data in the form like HH-MM-SS?

Thankyou for your kind concern :)

Report message to a moderator

Re: handling the length of musical pieces [message #878 is a reply to message #872] Mon, 11 March 2002 00:41 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
according to ur requirement , u need only HH-MM-SS not the the date. so better use number datatype , which will store number of seconds. then u can change to HH-MM-SS any time

Report message to a moderator

Previous Topic: How to connect to other database from procedure
Next Topic: how to copy and insert all the values in a tuple that is having auto ID
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 05:55:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.