A genuinely insightful and practical article. I recognise a good article when I go away and try it immediately. Thank you. 

Don't know how I didn't spot this article first time round! Great. Made me believe I can start fiddling around with the SQL...

Johnathan's method works very well, but a slight amendment is required otherwise it cuts the first character off the front. The command should read :

SELECT RIGHT(STUFF(CONVERT(char(26),GETDATE(),9),21,4,' '),11)

Thanks Jonathan. That's a...