sql make time in datetime 12 pm : I have datetime field as
<pre>
03/04/2016 08:00:00 AM
03/15/2016 04:00:00 AM
</pre>
I want to keep it as date time but make all the time to 12 am.So the result should be
<pre>
03/04/2016 12:00:00 AM
03/15/2016 12:00:00 AM
</pre>

No t-sql or declaring variables. Please advice.
