use this.

SELECT TOP 10 key_value

,convert(datetime2,BPK.key_value) as DT2

,convert(datetime,CONVERT(DATETIME2, PV.key_value)) AS DT

FROM parameter_value PV

WHERE PV.datatype = 'D'

and convert(datetime2,replace(PV.key_value,right(PV.key_value,4),'')) BETWEEN GETDATE() and DATEADD(d, 10, GETDATE())