I am trying to convert how I see a date from a select statement.
Right now I am getting date from my table like this. select LogDate from TestLog with (nolock)
And the output is 2011-08-16 09:45:33.260
Is there a way to do the select so I see the date as mmyyyy ?