No that is not I am expecting. The image must display in the outlook message body area.

SELECT CONVERT(VARCHAR(10),GETDATE(),121);

Output: 2013-06-12

Example:-

SELECT CONVERT(VARCHAR(10),ContractEndDate,121)

From TestDataTable_Archive;

You can Play with the different format values like 111 etc.

SELECT CONVERT(VARCHAR(10),GETDATE(),111);

Output: 2013/09/30