[Solved] Convert 11/22/2016 12:37:51 PM SQL QUERY [closed]

Just try casting it as a DATE:

SELECT CAST(YourTimestampField AS DATE) AS MyDateField