Hi, I'm having problem at the moment trying to parse a date. I'm reading in 2 dates from the view and want to search a DB for records between the 2 dates.
The 2 dates I read are in the format '%d.%m.%Y', e.g. 22.04.2009 The dates in the DB are stored as VARCHAR in the format '%Y/%m/%d %H:%M:%S' I've set the default date in environments.db as follows: ActiveSupport::CoreExtensions::Time::Conversions::DATE_FORMATS.merge!( :default => '%d.%m.%Y' ) I've tried parsing the 2 dates as follows: Time.parse(params[:from]).strftime("%Y/%m/%d") However the result is incorrect for my locale. If I read in a date '12.04.2009' I would get the following output: 2009/12/04, when what I want is 2009/04/12. It's getting the day and month mixed. The Locale on my machine is correct and the timezone in the environments.db is set to UTC. -- 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---