Convert datetime to mysql format on Ruby on Rails

Question

i´m trying to convert a date to mysql format date but is not working.

@complain.date = Date.today.to_s(:db)

Also, i want to save it as datetime format. Any suggests??

Aren't you using date fields when you create your migrations, in which case rails will do it for you. — Gazler
– Gazler, Commented Apr 6, 2011 at 20:34
Time.now.to_s(:db) or Time.now.strftime("%Y-%m-%d %H:%M:%S") — Fivell
– Fivell, Commented Apr 6, 2011 at 20:39

Sophie Alpert · Accepted Answer · 2011-04-06 20:46:13Z

10

You don't need to convert manually; just do:

@complain.date = Date.today

answered Apr 6, 2011 at 20:46

Sophie Alpert

144k37 gold badges229 silver badges244 bronze badges

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

2 Comments

Remember that this only returns the Date. If you have a column of DATETIME type, you should use Time.now.to_s(:db)

the :db is no joke!