SQL date time formatting

When writing queries you might sometimes come across those people clients who want the dates formatted in a certain way (pesky clients *shakes fist). Don’t stress its nothing too difficult.

Take the date 20th May 2014 and you get a request to convert this to dd/mm/yyyy.

We usually work in iso dates (yyyymmdd). For the example I will cast the iso date as a string and then cast it as a datetime and work from there.

Our final product will look something as follows:

I will go through what each of the steps entail.


Hello dev world!

A little about me
A big hello from The Lazy developer here is Aus. Been in development for a good 10 years now and have to say there’s been a few ups and downs here and there. Started learning Java at uni and progressed in various languages throughout my studies. Have to say though was a pretty fun experience learning new languages and techniques to develop solutions.

Currently been involved with silverlight, vb .net, vb6 and SQL dbs. Been at it for the last 5 years or so; so been an quite interesting learning curve.