how to remove seconds and milliseconds from a date

Viewed 11

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?

0 Answers
Related