2 ms·Yes, you can `DISTINCT ON` with a `DATE_TRUNC` expression which should get you what you want.by eyelidlessness 7y agoYes, you can `DISTINCT ON` with a `DATE_TRUNC` expression which should get you what you want.