Tag: ruby

operator does not exist: timestamp without time zone ~~* unknown ruby code

I am try to query users in the database when I do a search. However i am getting a specific error which is ‘operator does not exist: timestamp without time zone ~~* unknown’ In my database, the …

How to write a query to compare current date to created_at timestamps in database?

activerecord mysql ruby ruby-on-rails sql

I would like to write a query to compare created_at timestamp with my current date in Ruby on Rails using ActiveRecord and I don’t quite know how do it yet Date is stored like this -> created_at: …

Raills: Get SQL generated by delete_all

activerecord rails-activerecord ruby ruby-on-rails sql

I’m not particularly familiar with Ruby on Rails, but I’m troubleshooting an issue we’re experiencing with a rake job that is supposed to be cleaning database tables. The tables grow very large very …