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.