Format date to display only day and month (dd MMM) in SQL Query

narasima...

SOLVED CLOSED ACTIVE ANSWERED
User: narasiman
Posted: on May 16, 2014 04:07 AM
Forum: SQL Server
Answer: 1
Views: 7477

Display the date and month in sql.

select convert(varchar(11),cbm_batch_start_dt,106) as Course_date from co_batch_master where cbm_active <> 'D' and cbm_batch_start_dt = '01/13/2014' and cmn_minor_code in('RFPFF','R-AFF','RFPFF_C')

When i execute the above query shows output as follows 13 Jan 2014 17 Jan 2014 i want only date and month not year But i want output as follows 13 Jan 17 Jan for that how can i write query. Regards, Narasiman P.

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 1

Reply
ANSWER
User: Azim
Replied: on May 16, 2014 04:09 AM
Report

Run this code in the SQL Query analyzer

--This way
SELECT  DATENAME(DAY, GETDATE()) + ' ' + DATENAME(MONTH, GETDATE()) As CourseDate
-- Or you can reduce the size of varchar to 6
SELECT CONVERT(VARCHAR(6),GETDATE(),106) AS CourseDate

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Format date to display only day and month (dd MMM) in SQL Query

Company

Explore

Follow us

Contact Us