trying to change date time to non-military datetime

In what context?

Mary -

I'm assuming you want the a date field in a query from the standard format mm-dd-yyyy hh:mm:ss.xxx? If you are asking how to change it in SQL, you can use both the CONVERT or CAST function in your SQL query. There are many resources on the internet to explain how to use the function in your query. 

You would not want to change the field type of a table, however. 

Hope this helps.