Change a column type from Date to DateTime during ROR migration

mysql ruby-on-rails ruby ruby-on-rails-3 migration
jdog picture jdog · Mar 4, 2011 · Viewed 161.1k times · Source

I need to change my column type from date to datetime for an app I am making. I don't care about the data as its still being developed.

How can I do this?

Answer

apneadiving picture apneadiving · Mar 4, 2011

First in your terminal:

rails g migration change_date_format_in_my_table

Then in your migration file:

For Rails >= 3.2:

class ChangeDateFormatInMyTable < ActiveRecord::Migration
  def up
    change_column :my_table, :my_column, :datetime
  end

  def down
    change_column :my_table, :my_column, :date
  end
end

Related questions

How rails database connection pool works

I am learning rails database connection pool concept. In rails application I have defined pool size of 5. my understanding about connection pool size is as below. When server start rails automatically creates n number of connection defined in the database.…

Read More
Error installing mysql2: Failed to build gem native extension

I am having some problems when trying to install mysql2 gem for Rails. When I try to install it by running bundle install or gem install mysql2 it gives me the following error: Error installing mysql2: ERROR: Failed to build …

Read More
Create a new Ruby on Rails application using MySQL instead of SQLite

I want to create my Rails application with MySQL, because I like it so much. How can I do that in the latest version of Rails instead of the default SQLite?

Read More