Creating a Date type value in PostgreSQL

DATE('2023-08-21')

- or -

'2023-08-21'::DATE