I have a field named 'Modified' with a type of 'datetime'. It has entries that look like this:
2014-10-28 12:08:19.067
I want to convert these entries to this:
10/28/2014
But no matter what format I apply I get the same entry like this:
2014-10-28
For instance, when I try this:
Select CONVERT(Date, Modified , 101) as mod_test from NOTE
I should get 10/28/2014
But I don't. I can change the '101' to any number but I still get the same output. What am I missing? Thanks!
- Edited by Rhino_dance 9 hours 44 minutes ago