Databases
StackOverflow2013
Postsdbo
PORails config.time_zone and datetime attribute update
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORails config.time_zone and datetime attribute update
    text
    copied!<p>In my application I have: <code>config.time_zone = 'Warsaw'</code></p> <p>A strange issue I have, is that it seems like Rails are having problems with comparision of datetime fields. If I change the datetime 1 hour back (and Warsaw is currently in timezone +0100), Rails won't update the database, even if the field has changed. However, if I change the field once again, then the update will go to the database.</p> <p>Example:</p> <p>(Rails 3.1.0, ruby-1.9.2-p290, fresh rails app):</p> <pre><code>$ rails g model User starts_at:datetime $ rake db:migrate $ rails c Loading development environment (Rails 3.1.0) ruby-1.9.2-p290 :001 &gt; u = User.create({:starts_at =&gt; "2011-01-01 10:00"}) SQL (21.3ms) INSERT INTO "users" ("created_at", "starts_at", "updated_at") VALUES (?, ?, ?) [["created_at", Tue, 13 Dec 2011 11:32:50 CET +01:00], ["starts_at", Sat, 01 Jan 2011 10:00:00 CET +01:00], ["updated_at", Tue, 13 Dec 2011 11:32:50 CET +01:00]] =&gt; #&lt;User id: 1, starts_at: "2011-01-01 09:00:00", created_at: "2011-12-13 10:32:50", updated_at: "2011-12-13 10:32:50"&gt; ruby-1.9.2-p290 :002 &gt; u.starts_at =&gt; Sat, 01 Jan 2011 10:00:00 CET +01:00 # datetime created ruby-1.9.2-p290 :003 &gt; u.starts_at = "2011-01-01 09:00:00" # new datetime with one hour back =&gt; "2011-01-01 09:00:00" ruby-1.9.2-p290 :004 &gt; u.starts_at =&gt; Sat, 01 Jan 2011 09:00:00 CET +01:00 # changed datetime ruby-1.9.2-p290 :005 &gt; u.save =&gt; true ruby-1.9.2-p290 :006 &gt; u.starts_at = "2011-01-01 09:00:00" =&gt; "2011-01-01 09:00:00" ruby-1.9.2-p290 :007 &gt; u.save (0.3ms) UPDATE "users" SET "starts_at" = '2011-01-01 08:00:00.000000', "updated_at" = '2011-12-13 10:33:17.919092' WHERE "users"."id" = 1 =&gt; true </code></pre> <p>I've tested it in this fresh app, because I have a problem with this in larger application. What is going on? I've tried to browse the Rails code, tried to re-copy the relevant code 'by-hand' in console (like update, assign_attributes, even checked time_zone_conversion) and it worked, but not in 'real world'..</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload