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
  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.