Select query to display date format as DAY MMM DD YYYY in SQL Server 2008

Question

I tried like this

SELECT DATENAME(DW,GETDATE()) + ' ' + CONVERT(VARCHAR(12), SYSDATETIME(), 107)

result

Thursday Dec 11, 2014

Required OutPut:

SELECT A REQUEST FOR DISPLAY DISC AS TO SHOW BELOW

Thu Dec 11, 2014

+3

Dinesh reddy alla Dec 11. 14 at 12:36

3 answers

All you need is to take only 3 characters of your day of the week:

SELECT LEFT(DATENAME(DW,GETDATE()),3) + ' ' + CONVERT(VARCHAR(12), SYSDATETIME(), 107)

+2

Timofey G Morozov Dec 11. 14 at 12:38

SELECT CONVERT(VARCHAR(3), DATENAME(DW,GETDATE())) + ' '
       + CONVERT(VARCHAR(12), SYSDATETIME(), 107)

+2

Veera Dec 11. 14 at 12:39

Matt · Accepted Answer · 2014-12-11T12:38:43+0000

SELECT LEFT(DATENAME(DW,GETDATE()),3) + ' ' + CONVERT(VARCHAR(12), SYSDATETIME(), 107) 
FROM yourtable