# HOWTO:DB data format stays in seconds yet user interface can use hh:mm:ss selector

**URL:** <https://www.ruby-forum.com/t/howto-db-data-format-stays-in-seconds-yet-user-interface-can-use-hhss-selector/143715>\
**Category:** Rails\
**Created:** [July 22, 2008, 3:58am UTC](https://www.ruby-forum.com/t/howto-db-data-format-stays-in-seconds-yet-user-interface-can-use-hhss-selector/143715 "2008-07-22T03:58:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nik](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/6de8d8/32.png) [@nik](https://www.ruby-forum.com/u/nik)\
**Post date:** [July 22, 2008, 3:58am UTC](https://www.ruby-forum.com/t/howto-db-data-format-stays-in-seconds-yet-user-interface-can-use-hhss-selector/143715/1 "2008-07-22T03:58:59Z")

</div>

Hello all,

my ‘time’ column in the DB is in integer representing the length of  
videos in seconds.

if I want to let the user pick a point in the movie and play it from  
there, I think it works better for the general public to use the  
HH:MM:SS format, which can easily be done.

Except that when I want to allow the user to save this timestamp for  
his/her future reference, so should I start looking for some solution  
relating to some feature of Model or should I stick with pure  
javascript?

Thank You!  
Nik