Hai

使用DateTime格式转换日期为你想要的，为此你需要为转换日期指定列名称，尝试使用

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 

如果没有工作请在mysql中通过转换日期时间，我在sql server中知道。



问候

AravindB

If not work pls go through convert datetime in mysql,i am known in sql server.

Regards
AravindB