sql server - best way to get iso into usa format -

An attempt to convert my date string into a UAA format

'20150316 16:28' 3/16/2015 4:28 PM '

(Note: 24hr format is also OK)

The predefined format" g "will give you a date time in this format:

  Choose FORMAT (Dot ('20150316 16:20' datetime form ),  

Update:

  Select the format (dot ('20150316 16:20' as datetime), ' D ') +' '+ Format (' 20150316 16:20 'day-time  

Production >

These articles are predefined and custom For Date Time Formats, see:

Note that these will vary according to culture.