How Can We Help?
CONVERT(VARCHAR(12),DATEADD(S, getdate(), '1970-01-01'),105)
Specification according to https://msdn.microsoft.com/library/ms187928
KB with my experience
CONVERT(VARCHAR(12),DATEADD(S, getdate(), '1970-01-01'),105)
Specification according to https://msdn.microsoft.com/library/ms187928