Don't have Telegram yet? Try it now!
https://mteheran.dev/2013/02/03/remove-hour-in-datetime-variable-using-sql-server/
Remove hour in DateTime variable using SQL SERVER