select 
TO_CHAR(TO_TIMESTAMP(date, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD') AS date_2

from 

where TO_TIMESTAMP(date_2, 'YYYY-MM-DD HH24:MI:SS')
      BETWEEN '2022-01-01'::DATE AND '2024-12-31'::DATE)