DATE型のカラムを検索する
OracleのDATE型
>> member = Member.find(10000) "id" "members" => #<Member:0xb339510c @attributes={"name"=>"maiha", "arrived_at"=>#<Date: 4903089/2,0,2299161>, "id"=>10000, "presence"=>2, "created_at"=>#<Date: 4903089/2,0,2299161>}> >> member.arrived_at NoMethodError: private method `gsub!' called for #<Date: 4903089/2,0,2299161>
アウチ!
MySQLのDATE型
>> car = Car.find(1) "id" "cars" => #<Car:0xb34a5cc4 @attributes={"name"=>"ferali", "updated_at"=>"2006-11- 26", "maker_id"=>nil, "arrived_at"=>"2006-11-26 12:08:00", "id"=>"1", "changed_at"=>"2006-11-26 12:08:00", "created_at"=>"2006-11-26 12:08:00"}> >> car.arrived_at => Sun Nov 26 12:08:00 JST 2006
なんか・・Oracleの場合はARのDATE型属性の文字列変換がされてないってことですか・・
(手抜き?)
MySQLのDATEの戻り値と同じにするにはこうすればよいみたいですけど・・・
>> Time.mktime member.created_at.year, member.created_at.month, member.created_at.day => Sat Jan 01 00:00:00 JST 2000
どーする?OracleでDATE。