When I request a value from a DATE type in an Oracle database, Sequel returns a Time object. However, this time object does not have any timezone associated with it and thus doesn't handle daylight savings time.
For example: # This time pulls out of the DB correctly because even though it doesn't have a timezone it uses the local timezone t = db[:my_table].select(:time).order(:time).first[:time] => 2008-11-07 10:38:52 -0700 t.class => Time t.zone => nil # This time pulls out of the DB incorrectly because it uses the local timezone of "now" instead of 8/27/2008 t = db[:my_table].select(:time).order(:time).first[:time] => 2008-08-27 09:15:50 -0700 t.class => Time t.zone => nil I've tried setting Sequel.default_timezone to all the options: nil, local, and utc but it has no effect. The time returned is always the same with all three options and it never has a timezone set. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
