How to use Time type in rails

rubyonrails-talk
1

I defines a table and one of its column type is Time. I use ruby Time class to assign the value to this column, but it always generate Sat Jan 01 2000 time. Is the format different with the database and ruby class? I use MySql database in Linux.

2

Are you using Time.now to assign the time?

3

Bobnation wrote:

Are you using Time.now to assign the time?

Yes, I use Time.now.

4

Can you post your schema.rb?

5

Bobnation wrote:

Can you post your schema.rb?

This is schema file:

class CreateHistories < ActiveRecord::Migration   def self.up     create_table :histories do |t|       t.string :user_name,:null=>false       t.string :project_name,:null=>false       t.string :view       t.string :task       t.date :date       t.time :time       t.string :log

      t.timestamps     end   end

  def self.down     drop_table :histories   end end

6

Do created_at and updated_at (via t.timestamps) get set properly? I think you could try using t.timestamp (not plural) instead of t.time.

Or, instead of using "sexy migrations", you could try doing it the old way: t.column :my_time_column, :datetime

Hope this helps, Jason Arora

7

jasoo24 wrote:

Do created_at and updated_at (via t.timestamps) get set properly? I think you could try using t.timestamp (not plural) instead of t.time.

Or, instead of using "sexy migrations", you could try doing it the old way: t.column :my_time_column, :datetime

Hope this helps, Jason Arora

How can I migrate this schema without breaking this table? I have tried to run "rake db:migrate" but it doesn't work.