placeholders in strings arent considered placeholders so perhaps you want to `||` concatenate the percent characters onto it instead: ```sql '%' || :date || '%' ``` but that seems like an odd thing to do for a plain `=` equality check on a date...
my database has dates that are like: `[2024-05-10....]` So Im basically only after the first bit the year month and day. I dont need the exact time So im after anything that's "like" a specific date.