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 · 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

DateTime Format in SQL

Answers (3)