ActiveRecord date format

ruby-on-rails activerecord date-format
Mongus Pong picture Mongus Pong · Mar 27, 2010 · Viewed 28.2k times · Source

I've run into a spot of bother with date formats in our Rails application.

I have a date field in our view which I want to be formatted as dd/mm/yy. This is how the user will expect to enter their dates, and the datepicker control uses this format.

However, Active Record seems to be expecting mm/dd/yy.

If I enter 01/03/2010, this gets put in as 03 January 2010.

If I enter 25/03/2010, this gets put in a null.

How do I get ActiveRecord to expect Her Majesties date format?

Answer

Marcel Jackwerth picture Marcel Jackwerth · Mar 27, 2010

Rails' DateTime tries to detect the formatting automatically. It will detect the following formats: mm/dd/yy or dd-mm-yy or yyyy-mm-dd or yyyy/mm/dd. You could monkey-patch DateTime.parse, but I would rather move this issue to the View of your application.

I always recommend to use yyyy-mm-dd [hh:mm:ss] as a string representation for a date. Check the documentation of your DatePicker if it supports multiple date-formats.

The jQuery date-picker for example has this covered with dateFormat (for the data that is sent to the server, set this to yyyy-mm-dd) as well as altFormat (for the input the user sees, set this to dd/mm/yyyy).

Related questions

How to change created_at format

This should be a simple thing. Well, Im sure it should be simple, this is rails. The problem is: in the model all data has a field created_at. to retrieve this info in the view I use a block, …

Read More
How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Rails: select unique values from a column

I already have a working solution, but I would really like to know why this doesn't work: ratings = Model.select(:rating).uniq ratings.each { |r| puts r.rating } It selects, but don't print unique values, it prints all values, including …

Read More