Return date as ddmmyyyy in SQL Server

Question

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

User · Answer

SELECT REPLACE CONVERT VARCHAR 10   THEDATE  103            AS  DDMMYYYY    As seen here  http   www sql-server-helper com tips date-formats aspx

User · Answer

Just for the record  since SQL 2012 you can use FORMAT  as simple as  SELECT FORMAT GETDATE     ddMMyyyy     op question is specific about SQL 2008

User · Answer

Try this   SELECT CONVERT DATE  STUFF STUFF  01012020   5  0   -    3  0   -    103     It works with SQL Server 2016

User · Answer

select replace convert VARCHAR getdate   103           select right convert VARCHAR getdate   112  2            substring convert VARCHAR getdate   112  5 2            left convert VARCHAR getdate   112  4

User · Answer

I ve been doing it like this for years   print convert char getdate   103

User · Answer

I found a way to do it without replacing the slashes  select CONVERT VARCHAR 10   GETDATE    112    This would return   YYYYMMDD

User · Answer

Try following query to format datetime in sql server FORMAT  frr valid from    dd MM yyyy hh mm ss

User · Answer

CONVERT style 103 is dd mm yyyy  Then use the REPLACE function to eliminate the slashes   SELECT REPLACE CONVERT CHAR 10    MyDateTime   103

[sql-server] Return date as ddmmyyyy in SQL Server

Examples related to sql-server

Examples related to sql-server-2005

Examples related to date-formatting