Found how to set the date format for DB conversion on the Rails side as
opposed to Oracle. It's good but it's not enough. I put the following in
overrides.rb:
module ActiveSupport #:nodoc:
module CoreExtensions #:nodoc:
module Date #:nodoc:
# Converting dates to formatted strings, times, and datetimes.
module Conversions
DATE_FORMATS[:db] = "%d-%b-%y"
end
end
end
end
This gives me , for Aug 13th 2010, 13-Aug-10. However, Oracle expects
12-AUG-10 (i.e. month all caps) and continues to reject the date on
save. Needless to say select continues to work mysteriously.
Need to figure out how to set NLS_DATE_FORMAT when the connection is
established.
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: 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/rubyonrails-talk?hl=en.
