concatenate 2 dates in SQL just like we do in Excel. I am using MS SQL server : In excel if we concat 2 dates for e.g 1/1/2015 and 7/1/2018 by using the formula =CONCAT(1/1/2015,"_",7/1/2018) the result is 42005_43282. 

Can we do the same thing in SQL?