Question

我非常迷惑了会出什么差错

我登录到 heroko 运行控制台 并试图更新数据库的时间戳。

我运行了 User.find(6) 来查看用户是否有 :next_lick = 2000-01... I don't know why its is that value, 但不管怎样, 我做了 user. upate 6, {:next_click {gt; time.utc(2015)/code>, 它似乎更新得恰如其分地说 2015-01-01 00:00:00 , 但是当我再做一次 User.find(6) 似乎时间已经回转了,因为它不是 2015-01-00:00 。



我真的搞不懂为什么没有,有洞察力吗?

见ATTACHED SCREENSHOT 

irb(main):033:0> User.update 6, {:next_click => Time.utc(2015) }
  User Load (34.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 6]]
   (1.8ms)  BEGIN
   (2.2ms)  UPDATE "users" SET "next_click" =  2015-01-01 00:00:00.000000 , "updated_at" =  2012-05-24 00:13:26.197358  WHERE "users"."id" = 6
   (2.2ms)  COMMIT
=> #<User id: 6, name: "mazlix", gold: 10, points: 10, next_click: "2015-01-01 00:00:00", created_at: "2012-05-23 23:40:39", updated_at: "2012-05-24 00:13:26">
irb(main):034:0> User.find(6)
  User Load (2.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 6]]
=> #<User id: 6, name: "mazlix", gold: 10, points: 10, next_click: "2000-01-01 00:00:00", created_at: "2012-05-23 23:40:39", updated_at: "2012-05-24 00:13:26">


u = user.find(6)  u.next_cick = Time.utc(2013)  then u.save 

irb(main):001:0> u = User.find(6)
  User Load (38.8ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 6]]
=> #<User id: 6, name: "mazlix", gold: 10, points: 10, next_click: "2000-01-01 00:00:00", created_at: "2012-05-23 23:40:39", updated_at: "2012-05-24 00:57:28">
irb(main):002:0> u.next_click = Time.utc(2013)
=> 2013-01-01 00:00:00 UTC
irb(main):003:0> u
=> #<User id: 6, name: "mazlix", gold: 10, points: 10, next_click: "2013-01-01 00:00:00", created_at: "2012-05-23 23:40:39", updated_at: "2012-05-24 00:57:28">
irb(main):004:0> u.save
   (10.9ms)  BEGIN
   (3.7ms)  UPDATE "users" SET "next_click" =  2013-01-01 00:00:00.000000 , "updated_at" =  2012-05-24 03:05:46.059530  WHERE "users"."id" = 6
   (2.2ms)  COMMIT
=> true
irb(main):005:0> u
=> #<User id: 6, name: "mazlix", gold: 10, points: 10, next_click: "2013-01-01 00:00:00", created_at: "2012-05-23 23:40:39", updated_at: "2012-05-24 03:05:46">
irb(main):006:0> User.find(6)
  User Load (33.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 6]]
=> #<User id: 6, name: "mazlix", gold: 10, points: 10, next_click: "2000-01-01 00:00:00", created_at: "2012-05-23 23:40:39", updated_at: "2012-05-24 03:05:46">


app/models/user.rb: 

class User < ActiveRecord::Base
  attr_accessible :gold, :name, :next_click, :points
end

Answer 1


您创建了一个时间列。 略为令人困惑的是, 尽管在 Ruby 中 < code>Time < /code> 存储时间+日期, 在数据库世界中, 纯日时间的概念( 即仅小时/ 分钟/ 秒) 存在, 而当您在迁移中添加一列类型 : 时间 。

Ruby 本身没有代表没有日期的时间的类, 所以铁路使用一个 < code>Time  实例, 但忽略日期位 。

如果您想要一个同时存储时间和日期的列, 请将列更改为: 日期 1: (在大多数情况下,您仍然可以得到一个 < code>Time 实例。

Answer 2

在您的活动记录中, 您可以使用数据类型 < code>:timestamp 或 : datetime 来保存正确的日期格式。

友情链接