# Rails translating mysql time field

**URL:** <https://www.ruby-forum.com/t/rails-translating-mysql-time-field/85644>\
**Category:** Rails\
**Created:** [February 15, 2007, 4:53am UTC](https://www.ruby-forum.com/t/rails-translating-mysql-time-field/85644 "2007-02-15T04:53:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ajtwatching](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/b9e5f3/32.png) [@ajtwatching](https://www.ruby-forum.com/u/ajtwatching)\
**Post date:** [February 15, 2007, 4:53am UTC](https://www.ruby-forum.com/t/rails-translating-mysql-time-field/85644/1 "2007-02-15T04:53:18Z")

</div>

I imagine this is a simple problem, however can’t seem to find the  
solution!

In one of my mysql tables, I have a “time” field for storing elapsed  
time, HH:MM:SS.

mysql\> select \* from rides;  
±—±----------±-----------+  
| id | ride\_time | ride\_date |  
±—±----------±-----------+  
| 1 | 00:37:44 | 2007-02-15 |  
±—±----------±-----------+

However when I get rails to list my rides, it does some funky business  
with the “ride\_time” field, namely adding a date.

Listing rides  
Ride time Ride date  
Sat Jan 01 00:37:44 EST 2000 2007-02-15 Show Edit Destroy

How do I just print the time?

Thanks,

ajt.

---

<div class="post-metadata">

**Author:** ![ajtwatching](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/b9e5f3/32.png) [@ajtwatching](https://www.ruby-forum.com/u/ajtwatching)\
**Post date:** [February 15, 2007, 4:59am UTC](https://www.ruby-forum.com/t/rails-translating-mysql-time-field/85644/2 "2007-02-15T04:59:18Z")

</div>

ajtwatching wrote:

> | 1 | 00:37:44 | 2007-02-15 |
> 
> Thanks,
> 
> ajt.

I’m not sure if this helps your problem, but take a look at strftime:  
[http://ruby-doc.org/core/classes/Time.html#M000255](http://ruby-doc.org/core/classes/Time.html#M000255)

Cheers,  
mohit.

---

<div class="post-metadata">

**Author:** ![ajtwatching](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/b9e5f3/32.png) [@ajtwatching](https://www.ruby-forum.com/u/ajtwatching)\
**Post date:** [February 15, 2007, 5:05am UTC](https://www.ruby-forum.com/t/rails-translating-mysql-time-field/85644/3 "2007-02-15T05:05:18Z")

</div>

Sorry, missed your reply…

But thanks… it was bang on!

---

<div class="post-metadata">

**Author:** ![ajtwatching](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/b9e5f3/32.png) [@ajtwatching](https://www.ruby-forum.com/u/ajtwatching)\
**Post date:** [February 15, 2007, 5:04am UTC](https://www.ruby-forum.com/t/rails-translating-mysql-time-field/85644/4 "2007-02-15T05:04:18Z")

</div>

I did a bit more research myself and stumbled upon this analysis.

[http://substantiality.net/articles/2006/10/16/date-time-and-datetime-in-ruby](http://substantiality.net/articles/2006/10/16/date-time-and-datetime-in-ruby)

I’ve tweaked my list page with a bit of this action:

\<%= ride.ride\_time.strftime(“%H:%M:%S”) %\>

and now it’s working as I’d expect!

ajt.