I have a datetime field that I need to convert into the format DDMONYY (27Aug12). I am currently using
convert(nvarchar(30),DateToConvert,13), but that also spits out the time. How can I easily convert a date to the format I need?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Instead of your hack with replace, why not just cast to the right data type? This doesn't need to be nvarchar and the only reason it contains time is because you included too many characters. You can of course apply your replace here as well (or you could do that at the client).
After a little bit more research I found the answer on the Microsoft cast and convert page. The date format 106 is the closest format to what I desire, except that it has spaces in it. Adding a replace to get rid of the spaces gets it into the proper format.