Hai
use DateTime format for convert date as u want,for this u need to specify the column name exactly for convert date,try to use
SELECT DATE_FORMAT(Paper_date, '%Y/%m/%d') FROM news_master WHERE NW_NewsDate between '2014-01-07 00:00:00' AND '2014-01-07 23:59:00' ORDER BY NW_SerialNo ASC
If not work pls go through convert datetime in mysql,i am known in sql server.
Regards
AravindB