R – i need to update the current time in a sql query

rubyruby-on-rails

Usage of Time.now or Time.now.to_s or Time.now.to_datetime is throwing error.

Usage of Date.today doesn't help as it stores the date with time as 12.00 AM and not the current time stamp.

Please help me in resolving this issue.

Best Solution

I'm not sure why and what is throwing an error, but if you're trying to generate a date string that is correct SQL from Ruby (specifically Rails here) you can use Time.now.to_s(:db).

Related Solutions

R – Unit testing code which gets current time

Mocking Time.now or Date.today seems straightforward enough, would look something like:

require 'rubygems'
require 'test/unit'
require 'mocha'

class MyClass

  def foo
    Time.now
  end

end

class MyTest < Test::Unit::TestCase

  def test_foo
    assert true
    t = Time.now
    Time.expects(:now).returns(t)
    assert_equal t, MyClass.new.foo
  end

end

Ruby-on-rails – Rails :include vs. :joins

It appears that the :include functionality was changed with Rails 2.1. Rails used to do the join in all cases, but for performance reasons it was changed to use multiple queries in some circumstances. This blog post by Fabio Akita has some good information on the change (see the section entitled "Optimized Eager Loading").

Best Solution

Related Solutions

R – Unit testing code which gets current time

Ruby-on-rails – Rails :include vs. :joins

Related Question