title: Incorrect datetime value; Ruby on Rails
body: <p>I am running a test with mailers within Ruby on Rails, and I am getting the following errors:</p>
  
  <pre><code>*********-C02MGBVJFD57:myapp ************$ bundle exec rake test:mailers
  
  # Running:
  
  EE
  
  Finished in 0.110500s, 18.0995 runs/s, 0.0000 assertions/s.
  
    1) Error:
  UserMailerTest#test_account_activation:
  ActiveRecord::StatementInvalid: Mysql2::Error: Incorrect datetime value: '2014-12-18 01:07:49 UTC' for column 'activated_at' at row 1: INSERT INTO `users` (`name`, `email`, `password_digest`, `admin`, `activated`, `activated_at`, `created_at`, `updated_at`, `id`) VALUES ('Michael Example', 'michael@example.com', '$2a$04$hz6pvZctid6gZEuv0.qAe.0mEfbEjxso9GrXwC3yHRhIThIJ7Vx5m', 1, 1, '2014-12-18 01:07:49 UTC', '2014-12-18 01:07:49', '2014-12-18 01:07:49', 762146111)
  
  
  
    2) Error:
  UserMailerTest#test_password_reset:
  ActiveRecord::StatementInvalid: Mysql2::Error: Incorrect datetime value: '2014-12-18 01:07:49 UTC' for column 'activated_at' at row 1: INSERT INTO `users` (`name`, `email`, `password_digest`, `admin`, `activated`, `activated_at`, `created_at`, `updated_at`, `id`) VALUES ('Michael Example', 'michael@example.com', '$2a$04$XTAWn5P9kikgOXqxQgiJqOjP027p4HnucHZ6pth2aaLwolaFcehsm', 1, 1, '2014-12-18 01:07:49 UTC', '2014-12-18 01:07:49', '2014-12-18 01:07:49', 762146111)
  
  
  2 runs, 0 assertions, 0 failures, 2 errors, 0 skips
  </code></pre>
  
  <p>When I check my fixtures users.yml file, I see that I am using the time zone ruby stamp:</p>
  
  <pre><code>michael:
    name: Michael Example
    email: michael@example.com
    password_digest: &lt;%= User.digest('password') %&gt;
    admin: true
    activated: true
    activated_at: &lt;%= Time.zone.now %&gt;
  
  archer:
    name: Sterling Archer
    email: duchess@example.gov
    password_digest: &lt;%= User.digest('password') %&gt;
    activated: true
    activated_at: &lt;%= Time.zone.now %&gt;
  
  lana:
    name: Lana Kane
    email: hands@example.gov
    password_digest: &lt;%= User.digest('password') %&gt;
    activated: true
    activated_at: &lt;%= Time.zone.now %&gt;
  
  mallory:
    name: Mallory Archer
    email: boss@example.gov
    password_digest: &lt;%= User.digest('password') %&gt;
    activated: true
    activated_at: &lt;%= Time.zone.now %&gt;
  
  &lt;% 30.times do |n| %&gt;
  user_&lt;%= n %&gt;:
    name:  &lt;%= "User #{n}" %&gt;
    email: &lt;%= "user-#{n}@example.com" %&gt;
    password_digest: &lt;%= User.digest('password') %&gt;
    activated: true
    activated_at: &lt;%= Time.zone.now %&gt;
  &lt;% end %&gt;  
  </code></pre>
  
  <p>and my db/seeds.rb file looks like so:</p>
  
  <pre><code>User.create!(name:  "Example User",
               email: "example@railstutorial.org",
               password:              "foobar",
               password_confirmation: "foobar",
               admin: true,
               activated: true,
               activated_at: Time.zone.now)
  
  99.times do |n|
    name  = Faker::Name.name
    email = "example-#{n+1}@railstutorial.org"
    password = "password"
    User.create!(name:  name,
                 email: email,
                 password:              password,
                 password_confirmation: password,
                 activated: true,
                 activated_at: Time.zone.now)
  end
  </code></pre>
  
  <p>EDIT: Here are the tests</p>
  
  <p>test/mailers/user_mailer_test.rb:</p>
  
  <pre><code>require 'test_helper'
  
  class UserMailerTest &lt; ActionMailer::TestCase
  
    test "account_activation" do
      mail = UserMailer.account_activation
      assert_equal "Account activation", mail.subject
      assert_equal ["to@example.org"], mail.to
      assert_equal ["from@example.com"], mail.from
      assert_match "Hi", mail.body.encoded
    end
  
    test "password_reset" do
      mail = UserMailer.password_reset
      assert_equal "Password reset", mail.subject
      assert_equal ["to@example.org"], mail.to
      assert_equal ["from@example.com"], mail.from
      assert_match "Hi", mail.body.encoded
    end
  end
  </code></pre>
  
  <p>Is there something I am doing wrong?  Thank you for your help.  </p>