Re: [SQL] Data Types

2001-02-16 Thread Josh Berkus
David, > However this gives me output that I don't know how to read: '7 02:34:27' > Does that read as 7 Days, 2 Hours, 34 Minutes and 27 seconds? Yes. -Josh Berkus -- __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete inf

[SQL] Data Types

2001-02-16 Thread David Olbersen
Hello. I have a table in which I'm trying to store the length of a sound file. I decided to use the TIME data type. Was this correct? One of the operations I want to do is sum() all of my files lengths to get the total amount in terms of time, of sound that I have. I notice that sum() doesn't ta