how to insert sql timestamp value into datetime type in rails?

Question

date = Date.today     
query = "insert into custom_reports(name,description,created_at) values(#{report_name}, #{report_content}, #{date})"
ActiveRecord::Base.connection.execute(query);

it inserts

0000-00-00 00:00:00

So thought of going the mysql timestamp way. Is it possible to do?

Answer 1

This should work

query = "insert into custom_reports(name,description,created_at) values('#{report_name}', '#{report_content}', '#{Time.now}')"