Gianluca Sartori (3/23/2012)

---

Thank you, Koen.
The BOL page for CONVERT is linked in the "built-in method so far" section. unfortunately hyperlinks are not easy to spot both on the forums and on the articles. The font is not much different from the regular text and I decided to emphasizes it with bold.

surreydude. (3/23/2012)

---

No mention of ISO date formats?

If the discussion is around how to present locale-specific date formats I would understand, but when converting dates an international standard must be one of the things that should be considered to detect malformed dates and prevent transposed dates.

Of course, it might just be easier to get the yanks to comply with the rest of the world in the first place!

David McKinney (3/23/2012)

---

I think this is a great article, with a lot of tasty code to chew over.

Thanks for putting in the effort and sharing!

charles.southey (3/23/2012)

---

If you want a commercially-supported CLR-based utility for this our SQLUtilities product includes a wide range of date formatting & parsing functions, as well as other useful date/time, string handling and numeric functions (e.g. return a dynamically-generated sequence of dates and/or times as a table-valued function).

Charles Southey
www.totallysql.com