Geoff Buesing

@Joel Hoffman -- you're right, my previous diagnosis of what was causing the problem was incorrect: a string assigned to a Date column is coerced to a Date obje...

Ok here's some compelling pro-"Kyiv " evidence:

1. US State department refers to it as Kyiv: http://www.state.gov/r/pa/ei/bgn...

2. Ukrainian constitution states ...

Did some quick Google research, found this article, "Kiev or Kyiv?": http://www.infoukes.com/faq/kyiv-2/

"The major academics, however, such as the world's lead...

I assume you're talking about a sql :time (i.e., time-only) column, which AR returns as an instance of Time, with year, month and day set to Jan 1, 2000.

Rails ...

That would work. Though you should use the non-destructive #getutc instead of #utc, otherwise you might get some unexpected behavior.

Aha ok -- looks like you're not calling #to_s(:db) -- 'Sun Apr 12 11:40:05 UTC 2009' is the plain Time#to_s output.

You need to explicitly call #to_s(:db) on ti...

If you include the UTC offset and leave out the MSK/MDK from the string, it works:

>> zone = ActiveSupport::TimeZone['Moscow']
=> #<ActiveSupport::TimeZone:...

In your environment.rb, are you setting config.time_zone? This setting currently only works when your database stores UTC times -- if you want to store in local...

I agree this is inconsistent -- TimeWithZone and Time.utc instances report themselves to the database as UTC, whereas Time.local instances report themselves in ...