Postgres ::date not working on Custom Query

[sid]

Try this instead of casting to date: TO_CHAR(created_at, 'YYYY-MM-DD')

Knex handles dates weirdly. Refer this: Timestamp Column Converted to UTC In Wappler