Code has been added to clipboard!

Use of SQL CONVERT

Example
CONVERT(VARCHAR(19),GETDATE())
CONVERT(VARCHAR(10),GETDATE(),110)
CONVERT(VARCHAR(10),GETDATE(),10)
CONVERT(VARCHAR(11),GETDATE(),106)
CONVERT(VARCHAR(11),GETDATE(),6)
CONVERT(VARCHAR(24),GETDATE(),113)