SQL DATETIME FORMATS

1. SELECT convert(datetime, 'Oct 23 2012 11:01AM', 100) -- mon dd yyyy hh:mmAM (or PM)
2. SELECT convert(datetime, 'Oct 23 2012 11:01AM') 
3. SELECT convert(datetime, 'Oct 23 12 11:01AM', 0) -- mon dd yy hh:mmAM (or PM)
4. SELECT convert(datetime, 'Oct 23 12 11:01AM') 
5. SELECT convert(datetime, '10/23/2016', 101) -- mm/dd/yyyy
6. SELECT convert(datetime, '2016.10.23', 102) -- yyyy.mm.dd
7. SELECT convert(datetime, '23/10/2016', 103) -- dd/mm/yyyy
8. SELECT convert(datetime, '23.10.2016', 104) -- dd.mm.yyyy
9. SELECT convert(datetime, '23-10-2016', 105) -- dd-mm-yyyy
10. SELECT convert(datetime, '23 OCT 2016', 106) -- dd mon yyyy
11. SELECT convert(datetime, 'Oct 23, 2016', 107) -- mon dd, yyyy
12. SELECT convert(datetime, '20:10:44', 108) -- hh:mm:ss
13. SELECT convert(datetime, 'Oct 23 2016 11:02:44:013AM', 109) 
14. SELECT convert(datetime, '10-23-2016', 110) -- mm-dd-yyyy
15. SELECT convert(datetime, '2016/10/23', 111) -- yyyy/mm/dd
16. SELECT convert(datetime, '20161023', 112) -- yyyymmdd
17. SELECT convert(datetime, '23 Oct 2016 11:02:07:577', 113) -- dd mon yyyy hh:mm:ss:mmm
18. SELECT convert(datetime, '20:10:25:300', 114) -- hh:mm:ss:mmm(24h)
19. SELECT convert(datetime, '2016-10-23 20:44:11', 120) -- yyyy-mm-dd hh:mm:ss(24h)
20. SELECT convert(datetime, '2016-10-23 20:44:11.500', 121) -- yyyy-mm-dd hh:mm:ss.mmm
21. SELECT convert(datetime, '2008-10-23T18:52:47.513', 126) -- yyyy-mm-ddThh:mm:ss.mmm
22. SELECT convert(datetime, STUFF(STUFF('31012016',3,0,'-'),6,0,'-'), 105)
23. SELECT convert(datetime, '10/23/16', 1) -- mm/dd/yy
24. SELECT convert(datetime, '16.10.23', 2) -- yy.mm.dd
25. SELECT convert(datetime, '23/10/16', 3) -- dd/mm/yy
26. SELECT convert(datetime, '23.10.16', 4) -- dd.mm.yy
27. SELECT convert(datetime, '23-10-16', 5) -- dd-mm-yy
28. SELECT convert(datetime, '23 OCT 16', 6) -- dd mon yy
29. SELECT convert(datetime, 'Oct 23, 16', 7) -- mon dd, yy
30. SELECT convert(datetime, '20:10:44', 8) -- hh:mm:ss
31. SELECT convert(datetime, 'Oct 23 16 11:02:44:013AM', 9)
32. SELECT convert(datetime, '10-23-16', 10) -- mm-dd-yy
33. SELECT convert(datetime, '16/10/23', 11) -- yy/mm/dd
34. SELECT convert(datetime, '161023', 12) -- yymmdd
35. SELECT convert(datetime, '23 Oct 16 11:02:07:577', 13) -- dd mon yy hh:mm:ss:mmm
36. SELECT convert(datetime, '20:10:25:300', 14) -- hh:mm:ss:mmm(24h)
37. SELECT convert(datetime, '2016-10-23 20:44:11',20) -- yyyy-mm-dd hh:mm:ss(24h)
38. SELECT convert(datetime, '2016-10-23 20:44:11.500', 21) -- yyyy-mm-dd hh:mm:ss.mmm