Return date as ddmmyyyy in SQL Server

sql-server sql-server-2005 date-formatting
Matt picture Matt · Jul 21, 2011 · Viewed 129.8k times · Source

I need the date as ddmmyyyy without any spacers.

How can I do this?

I can get yyyymmdd using CONVERT(VARCHAR, [MyDateTime], 112)

But I need the reverse of this.

SQL Server 2008

Answer

Joe Stefanelli picture Joe Stefanelli · Jul 21, 2011

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

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

Related questions

How to display a day from the Date

Using SQL Server 2005 Table1 Date 19-12-2009 20-12-2010 ..... Date Column datatype is DATETIME. Expected Output Monday Tuesday How to make a query for getting the day...

Read More
SQL Server Datetime issues. American vs. British?

On my test DB, the dates are displayed in a DD/MM/YYYY format. By displayed I mean when you right click, open table in Management Studio, the returned data are displayed in a DD/MM/YYYY format. Funny thing …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More