Search code examples
mysqlaudiojquery-ui-sortablesqldatatypes

What is the preferred data type for audio/video track length?


The app retrieves audio tracks and uses a service to get the length of the track, in hh::mm:ss format.
since it's formatted as time, but it's not an actual valid time value, I need some sortable representation of the data.

  1. What is your recommendation?
  2. How can it be sorted/searched/filtered?

thanks


Solution

  • Well, the answer is : using the time dataType... it's an actual time representation field.