Change a column type from Date to DateTime during ROR migration

Question

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

User · Answer

There s a change column method  just execute it in your migration with datetime as a new type   change column  my table   my column   my new type

User · Answer

Also  if you re using Rails 3 or newer you don t have to use the up and down methods  You can just use change   class ChangeFormatInMyTable  lt  ActiveRecord  Migration   def change     change column  my table   my column   my new type   end end

User · Answer

First in your terminal   rails g migration change date format in my table   Then in your migration file   For Rails    3 2   class ChangeDateFormatInMyTable  lt  ActiveRecord  Migration   def up     change column  my table   my column   datetime   end    def down     change column  my table   my column   date   end end

User · Answer

In Rails 3 2 and Rails 4  Benjamin s popular answer has a slightly different syntax   First in your terminal     rails g migration change date format in my table   Then in your migration file   class ChangeDateFormatInMyTable  lt  ActiveRecord  Migration   def up    change column  my table   my column   datetime   end    def down    change column  my table   my column   date   end end

User · Answer

AFAIK  migrations are there to try to reshape data you care about  i e  production  when making schema changes  So unless that s wrong  and since he did say he does not care about the data  why not just modify the column type in the original migration from date to datetime and re-run the migration   Hope you ve got tests

[mysql] Change a column type from Date to DateTime during ROR migration

Examples related to mysql

Examples related to ruby-on-rails

Examples related to ruby

Examples related to ruby-on-rails-3

Examples related to migration