If SQL Server 2012+ you can use the format() function
select format(cast('7/4/2016 5:00:00 Am' as datetime),'MMMM d, yyyy')
Returns
July 4, 2016
solved Convert m/d/yyyy H:MM:SS am/pm to “month d, yyyy” in SQL
If SQL Server 2012+ you can use the format() function
select format(cast('7/4/2016 5:00:00 Am' as datetime),'MMMM d, yyyy')
Returns
July 4, 2016
solved Convert m/d/yyyy H:MM:SS am/pm to “month d, yyyy” in SQL