How to use Time type in rails


#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

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.


#7

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