instead of going concatinating like this

@EndDate + '23:59:00.000'

you can use convert function  and then convert to sepcified format

say

CONVERT(DATETIME,CONVERT(VARCHAR,getdate(),101),101)

gives the following format.

2006-02-06 00:00:00.000

hope this will helpfull.

Dhanu 🙂