If you want to include the time with the date use the DATETIME function in the CAST instead of DATE.

Also What is suggested is not to just convert the three dates used in the example but that you populate a temporary table and use that as input to cast datetime formats of the input to the common format you want.