AND DS_COMPETENCIAF
between CONVERT(DATETIME, '2019-01-01 23:59:59', 102)
    AND CONVERT(DATETIME, '2019-01-01 23:59:59', 102)

select DATA
    , CONVERT(DATETIME, '2019-01-01 00:00:00', 102) AS DATACOMPARARUM
    , CONVERT(DATETIME, '2019-01-01 23:59:59', 102) AS DATACOMPARARDOIS
    from tabela