Time Zones, Ruby on Rails, and MySQL

Time Zones, Ruby on Rails, and MySQL : programming

reddit.com 11 Jan '13, 2am

Time Zones, Ruby on Rails, and MySQL

Time zones in Rails can be a little confusing because they add support by modifying existing Ruby core/stdlib classes. Ruby has no time zone support but Rails actually does a good job. The key is to always use Time.zone rather than Time and to be aware of the difference between things like Date.today (standard Ruby that isn't TZ aware) and Date.current (Rails added TZ aware). Outside of that it's easy to convert times to different zones or wrap a block of code it a particular zone by using use_zone . It'll adjust for TZ differences when comparing zones, etc. Unix timestamps reduce readability by humans (for example, when you're querying from the MySQL console). Additionally, unix timestamps can have a more limited range than a string representation. For example, some systems don't implement support for negative timestamp values.

Full article: http://www.reddit.com/r/programming/comments/16cphg/time_...

Tweets

@REDDITSPAMMOR » 11 Jan '13, 2am
#reddit Time Zones, Ruby on Rails, and MySQL: submitted by ianlotinsky [link] [comment] [link] #rulez
@CloudHavana » 11 Jan '13, 2am
Time Zones, Ruby on Rails, and MySQL [link]
@animesh1977 » 11 Jan '13, 4am
Time Zones, Ruby on Rails, and MySQL [link]
@msusies » 11 Jan '13, 2am
Time Zones, Ruby on Rails, and MySQL: submitted by ianlotinsky [link] [comment] [link]
@SyntressTech » 11 Jan '13, 2am
Time Zones, Ruby on Rails, and MySQL - submitted by ianlotinsky [link] [comment] [link]
@predditfeed » 11 Jan '13, 2am
Time Zones, Ruby on Rails, and MySQL: submitted by ianlotinsky [link] [comment] [link]
@sl2mmer » 11 Jan '13, 2am
Time Zones, Ruby on Rails, and MySQL [link]