P
Pure Deal
Guest
I have a catalogue of movies. Each movie has a duration. On the frontend of my application I would like to display the movie duration as
1 hour and 20 minutes (or whatever the duration is)
I'm thinking of using 2 drop-down to get the users input. First one captures the hour second the minutes. I will then store this in a DateTime field in SQL unless someone has a better alternative. So I assume 1hr 20 would be stored something like 00:01:20:00
Once all the durations are stored in the database I would like to sort the durations by shortest to longest or the other way around.
How could I do that?
Continue reading...
1 hour and 20 minutes (or whatever the duration is)
I'm thinking of using 2 drop-down to get the users input. First one captures the hour second the minutes. I will then store this in a DateTime field in SQL unless someone has a better alternative. So I assume 1hr 20 would be stored something like 00:01:20:00
Once all the durations are stored in the database I would like to sort the durations by shortest to longest or the other way around.
How could I do that?
Continue reading...