我正在使用Postgres数据库进行Rails项目.对于我的一个模型,我有一个时间列,称为(巧妙地)时间.创建模型时,我将此列的数据类型设置为时间",(可能不正确)理解该数据类型仅用于存储时间,而没有日期.
I am working on a Rails project using a Postgres database. For one of my models, I have a time column, called (cleverly) time. When I created the model, I set the data type for this column as 'time', with the (perhaps incorrect) understanding that this data type was for storing time only, no date.
t.time :time但是,当我向模型提交数据时,时间是正确的,但以不正确的日期为前缀:
However, when I submit data to the model, the time is correct but prefixed by an incorrect date:
time: "2000-01-01 16:57:19"我只希望该列存储时间(例如'16:57:19'). 时间"是否是要使用的正确数据类型?还是有其他方法可以解决这个问题?
I just want the column to store the time (like '16:57:19'). Is 'time' the correct data type to use? Or is there some other way I should handle this problem?
非常感谢您.
推荐答案问题是Ruby或Rails中没有时段.所有时间类别都是日期或时间戳(即日期加上一天中的时间).
The problem is that there is no time-of-day class in Ruby or Rails. All the time classes are dates or timestamps (i.e. date plus time of day).
在数据库内部,它将是 time (无时区)列,它将在数据库内部正常运行.但是,一旦时间进入Ruby,ActiveRecord将添加一个日期组件,因为没有可用的普通时间类,因此恰好使用2000-01-01作为日期.
Inside the database it will be a time (without timezone) column and it will behave properly inside the database. However, once the time gets into Ruby, ActiveRecord will add a date component because there is no plain time-of-day class available, it just happens to use 2000-01-01 as the date.
在数据库内部一切都会好起来的,但是当您不在Rails的数据库外部时,您必须格外小心,以忽略日期部分.
Everything will be fine inside the database but you'll have to exercise a little bit of caution to ignore the date component when you're outside the database in Rails.
更多推荐
Rails Activerecord/Postgres时间格式
发布评论