How to achieve (05 Jan 2017) date fromat

Question

I am new to SQL Server and trying to get date from database in the requested format.

I am trying this query to achieve the result.

select * 
from datetable

did you even attempt to research this problem. there are numerous similar questions on the site. — Tanner, Jan 06 '17 at 11:39

score 1 · Answer 1 · answered Jan 06 '17 at 11:30

1

Another option is Format()

Select Format(somedate,'dd MMM yyyy')

answered Jan 06 '17 at 11:30

John Cappelletti

1

worth noting this is 2012+ as OP didn't specify version. – Tanner Jan 06 '17 at 11:40
@Tanner Fair enough, but it is generally assumed the SQL Server tag is for currently supported versions which is 2012+. That said, I've been surprised numerous times. – John Cappelletti Jan 06 '17 at 11:44
You know what they say about assumptions... :-) – Tanner Jan 06 '17 at 11:45
@JohnCappelletti 2008 & 2008R2 are under Extended Support for 2 more years – alroc Jan 06 '17 at 12:12
@alroc Huh. Good to know. Thanks – John Cappelletti Jan 06 '17 at 12:15

score 0 · Accepted Answer · answered Jan 06 '17 at 11:28

0

you can use convert function to get required result.

select convert(varchar,getdate(),106)

Result:

06 Jan 2017

answered Jan 06 '17 at 11:28

Shahzad Riaz

score 0 · Answer 3 · answered Jan 06 '17 at 11:29

0

If your datatype is DATETIME or DATETIME2 then you can use CONVERT()

SELECT CONVERT(VARCHAR(12), DATECOLUMN, 106)
FROM DateTable

answered Jan 06 '17 at 11:29

Radu Gheorghiu

score 0 · Answer 4 · answered Jan 06 '17 at 11:29

0

select *,Convert(varchar,DateColumn,106) as NewDate  from datetable

answered Jan 06 '17 at 11:29

Anurag_Soni

4 Answers4