Every now and then we will need to convert datetime to string for display, and would you remember all the format available? Apart from the one you commonly used, you won't, I know I don't! The most common one was below:
convert(varchar, getdate(), 121)
However, if you want other format, you might have to keep trying or look it up on BOL, I come up with a script that can help you just for that. It's a stored proc that you place on master database, and you can execute it anywhere. It save many minutes of my time and I help it can helps you too.