Sqlite crazy timezone

So as Maricio is pointing out, Rails stores the time in UTC format by default, but you can set it to display the time in the preferred zone format. For example, I am in the eastern time zone and would like my application to display time in EST. To do that, use the following setting in RAILS_ROOT/config/environment.rb file:

  # Make Time.zone default to the specified zone, and make Active Record store time values   # in the database in UTC, and return them converted to the specified local zone.   # Run "rake -D time" for a list of tasks for finding time zone names.   config.time_zone = "Eastern Time (US & Canada)"

To see other time zones available and how to represent them in time zone string as shown above, please lookup the Rails documenation.

Hope this helps.

Bharat