SyntaxFix
Write A Post
Hire A Developer
Questions
Try this one too:
SELECT CONVERT(CHAR(8),GETDATE(),108)