Return date as ddmmyyyy in SQL Server

Question

I require the date in the format DDMMYYYY, without any spaces. How can I go about this? Using CONVERT, I can obtain yyyymmdd (VARCHAR, [MyDateTime], 112).

But I require the opposite of this. I am using the 2008 SQL Server.

Answer 1

CONVERT style 103 is dd/mm/yyyy. Then use the REPLACE function to eliminate the slashes.

SELECT REPLACE(CONVERT(CHAR(10), [MyDateTime], 103), '/', '')

I hope this helps you.