I have a column of type timestamp. I need to select all records by given date. In sql it's something like:
select * from "table" where "date"::date = '2015-08-22';
I tried following:
db('table').select().where('date::date', '=', date);
But this throws error
error: select * from "table" where "date::date" = $1 - column "date::date" does not exist
because knex place quotes wrong.
Is there any way to perform such query? Or I should use whereRaw?