Kris wrote:
Kevin Olbrich wrote: >>def dob_formatted=(value) >>> text_field or in_place_editor the customized default does come into >>> >> Date.today.to_s >>> >>> >>> "customer_id"=>"30", "reminder_cancel_date"=>nil, "amount"=>"300.00", >>> the nicer parts of RoR. So this is where I became stuck. I took some >>> > >> this, I think it's time to ask the list. >>> > > to take a format parameter. Fire up script/console and look at >>> > > >>> > ActiveSupport::CoreExtensions:
:Conversions::DATE_FORMATS >>> > --josh >>> >>-- >>Ed Howland >>http://greenprogrammer.blogspot.com >>_______________________________________________ >>Rails mailing list >>Rails@lists.rubyonrails.org >>http://lists.rubyonrails.org/mailman/listinfo/rails > > Be careful changing the default format. I had an issue lately where > doing this completely hosed MySQL. Bottom line is that ActiveRecord was > trying to insert dates into the database in the new default format, > instead of the way MySQL was expecting to get it. It resulted in empty > dates, but no real error. > > Twas quite a pain to track down. > > > _Kevin > www.sciwerks.com
Did you ever figure out how to fix this? I have the same problem, changing the default date format effects the way it is passed to mysql. I would think that the rails team could fix this somehow no?
-- Posted via http://www.ruby-forum.com/.
Not yet. That's on the back burner for the moment. I've just been using the default output for now and specifically changing it when necessary.
I think the fix for this is to define a default :db date format and modify the appropriate AR code to use that format when writing to the DB. That way you could change the default print format without affecting the DB writes. I think I first encountered this while the Trac was down, so I'll go submit a ticket on this (if there isn't one already).
_Kevin