DateTime Format in SQL

Question

hi everyone i have a  field in SQL  EP.joiningdate    which give me result as 2013-06-04 00:00:00.000 . while i want to get date in this format  04 Jun 2013  how can i do in this n SQL server??? thanks in advance

Mohsin Arif · Accepted Answer

hi  you just do this by    Convert ( varchar , EP.joiningdate , 106)  as  joiningdate   i think it solve your issue.

Rajanikant Hawaldar · Answer

Hi Kiran,   try this     Declare @dt NVARCHAR(20) Select @dt = REPLACE(CONVERT(CHAR(15), SalesDate, 106),' ',' - ') FROM SalesTable Refer this for other format Format Output Statement DD Mon YY               03 Mar 13             CONVERT(VARCHAR(9), GETDATE(), 6) DD Mon YYYY         03 Mar 2013         CONVERT(VARCHAR(11), GETDATE(), 106) Mon DD, YY             Mar 04, 13            CONVERT(VARCHAR(10), GETDATE(), 7) Mon DD, YYYY       Mar 04, 2013        CONVERT(VARCHAR(12), GETDATE(), 107) YY.MM.DD              13.03.04                CONVERT(VARCHAR(8), GETDATE(), 2) YYYY.MM.DD        2013.03.04            CONVERT(VARCHAR(10), GETDATE(), 102) YY/MM/DD            13/03/04                 CONVERT(VARCHAR(8), GETDATE(), 11) YYYY/MM/DD      2013/03/04             CONVERT(VARCHAR(10), GETDATE(), 111) YYMMDD              130304                   CONVERT(VARCHAR(6), GETDATE(), 12) YYYYMMDD          20130304            CONVERT(VARCHAR(8), GETDATE(), 112)

Sivakumar Koneti · Answer

Hello read once   https://www.w3schools.com/sql/sql_dates.asp