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)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter