如何从保存数据库中获取日期 [英] How to get date from database as it is saved

问题描述

我想把数据库的日期与我的查询相同如下



SELECT * FROM news_master WHERE NW_NewsDate介于'2014-01-07 00之间： 00:00'和'2014-01-07 23：59：00'ORDDER BY NW_SerialNo ASC



栏的输出Paper_date是2014年1月12日12： 00:00 AM但是数据库列包含Paper_date2014-01-19



所以我希望Paper_date的相同输出与数据库值相同，即2014- 01-19，那么什么是替代

i want to take a date as same as database my query as follows

SELECT * 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

output for column Paper_date is "1/12/2014 12:00:00 AM" but database column consists the Paper_date "2014-01-19"

So i want same output of Paper_date as same as database value i.e "2014-01-19" ,So what is alternate for this

推荐答案

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

这篇关于如何从保存数据库中获取日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！