I’m having a problem with dates (laugh if you must :).
$ rails --version
$ ruby --version
ruby 1.8.7 (2010-01-10 patchlevel 249) [x86_64-linux]
I have a bunch of data in a text file that I’d like to place in my
DB but am ending up with odd results when I save the data.
Here’s my model:
class CreateWaits < ActiveRecord::Migration def self.up create_table :waits do |t| t.string :location t.integer :reg_wait_min t.integer :lic_wait_min t.time :collection_time #This is the troublesome one t.timestamps end end
Here’s an interaction from the console. I make a new Wait and give it
a collection_time of Time.now. The resulting objects has a
collection_time that looks right, March, 2010. At this point I call
save and then search for the newly inserted data. It comes back with a
collection_time in 2000. Any ideas what’s going on? I’m new to rails
so any advice will be greatly appreciated.
w = Wait.new(:location => “Arl”,
:reg_wait_min => 13,
:lic_wait_min => 223,
:collection_time => Time.now())
=> #<Wait id: nil, location: “Arl”,
reg_wait_min: 13, lic_wait_min: 223,
collection_time: “2010-03-08 09:20:40”, #HERE
created_at: nil, updated_at: nil>
Wait.find(:all, :conditions => [“location = ‘Arl’”])
=> [#<Wait id: 2983, location: “Arl”, reg_wait_min: 13,
collection_time: “2000-01-01 09:20:40”, ## HUH?
created_at: “2010-03-08 14:20:55”, updated_at: “2010-03-08
At this point w has also been updated to have the 2000 date.
thanks much for your help, Paul