Convert from datetime to varchar

Posted on by Michael Dyhr Iversen

How Can We Help?

Convert from datetime to varchar

Created On
byMichael Dyhr Iversen
You are here:
< Back
CONVERT(VARCHAR(12),DATEADD(S, getdate(), '1970-01-01'),105)

Specification according to https://msdn.microsoft.com/library/ms187928