From: Duc Qui <redmine@...>
Date: 2010-05-15T04:52:02+09:00
Subject: [ruby-core:30247] [Bug #3298] Returning of DateTime object from database

Bug #3298: Returning of DateTime object from database
http://redmine.ruby-lang.org/issues/show/3298

Author: Duc Qui
Status: Open, Priority: Normal
ruby -v: 1.8.7

I'm currently using
sequel 3.10.0, JDBC SQL Server.
ruby 1.8.7 (2010-01-10 patchlevel 249) [i386-mingw32]
jruby 1.4.0 (ruby 1.8.7 patchlevel 174) (2009-11-02 69fbfa3) (Java HotSpot(TM) Client VM 1.6.0_18) [x86-java]

I have a column 'created_at' with type DateTime in the SQL Server database. My goal is get the latest date (no time portion) using the following code

latest_date = Date.parse(max(:created_at))

Using ruby, this works fine because Date.parse takes String.
Using jruby, this fails because max(:created_at) is returning DateTime. Error says it cannot find method gsub! because it is not String.

The simple solution is to do Date.parse(max(:created_at).to_s).

Why does ruby and jruby differ in what type it returns?


----------------------------------------
http://redmine.ruby-lang.org