User.find(:first, :conditions => “mobile_number=’#{mobile_number}’ and
email=’#{email}’ and date_of_birth=’#{date_of_birth}’ and
secret_question=’#{secret_question}’ and
secret_answer=’#{secret_answer}’”)
ORA-01858: a non-numeric character was found where a numeric was
expected
but when i execute as query in BE its working well, anyhow, i’ve tried
using to_date(’#{date_of_birth}’, ‘dd-mon-yy’) the query executes well
with none record return, but i’ve the value of “20-SEP-90” on my db
anyway, i’ve a model Users with date_of_birth column with the type
of :date
any suggestions?
is there any difference between rails date and oracle date?