I'm trying to do some queries on the database of a Rails 2.3.2 app
configured with config.time_zone = 'Eastern Time (US & Canada)'. I
was under the impression that if I were to query the db for entries
that fall within a time range, that the time would automatically be
converted to UTC before executing the SQL, but that is not what I am
seeing.
Notice with .in_time_zone, it actually put the GMT offset as well as a
timezone identifier.
If you run queries with the first time object, it will disregard the
gmt offset and assume the time is local. If you run queries with the
second time object, it will convert the time to UTC first.