i have this query:
SELECT
movementdate
FROM m_transaction
WHERE client_id = 10
and movementdate<='2021-12-31'
All the movementdate are like DD-MM-YYYY HH-MM-SS format but i'd like to have only DD-MM-YYYY format. How can I do that?