I want to select date only
The convert function can do that. And if you want dd mm yyyy format 103 (with / separator) or 104 (with . separator) would be fine.

select c.InFavourOf as name,
       convert(varchar(10), c.ChequeDate, 103),
       p.Amount as amount,
       m.No as CNo
from Cheque c
  inner join PaymentDetail p 
    on c.MasterID= p.PaymentMasterID
  inner join PaymentMaster m 
    on p.ID=m.ID


If you want space separator, use replace function.

replace(convert(varchar(10), c.ChequeDate, 103), '/', ' ')