Rails saving datetime to MySQL database

Question

I have a simple function within my model to set a completed datetime column in a database. this function worked until I tried to change the default rails format for datetime.

After reading up on the issues with mysql datetime format and rails I decided to take out the formating code I had in the environment.rb

It still does not save though. I want it to save the same way that created_at etc. save. I can then format the display of the date.

I have restarted the web server

Model:

def self.complete(id)
   update(id, :completed_at => Time.now)
end

Controller:

Class.complete(params[:id])

Yannis · Accepted Answer · 2010-09-14 07:02:08Z

2

Since you want to update a specific instance of your class (a specific record), you may switch from a class method to an instance method.

In your model:

def complete
  update_attribute(:completed_at, Time.now)
end

and in your controller:

def your_method
  @object = YourModel.find(params[:id])
  @object.complete
end

answered Sep 14, 2010 at 7:02

Yannis

5,4261 gold badge33 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vise · Accepted Answer · 2010-09-14 06:56:09Z

1

You could try:

update(id, :completed_at => Time.now.to_s(:db))

answered Sep 14, 2010 at 6:56

vise

13.4k12 gold badges55 silver badges64 bronze badges

1 Comment

Rumpleteaser Over a year ago

I did try this earlier, unfortunately it made no difference.

Collectives™ on Stack Overflow

Rails saving datetime to MySQL database

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related