有关日期时间"SELECT QUERY"的问题吗? [英] Question related to date time SELECT QUERY?

问题描述

i have a table named Tbl_Product
having columns (id,PName,PTime)----

(1,Nokia,1/20/2012 7:02:09 PM)
(2,Samsung,1/21/2012 7:02:09 PM)
(3,Micromax,1/20/2012 7:02:09 PM)
(4,Tablet,1/21/2012 7:02:09 PM)
(5,Pendrive,1/20/2012 7:02:09 PM)
now i want to select data in a such manner date shoud be 1/20/2012

compare only 1/20/2012 and bind it to GridView.......help me....

推荐答案

尝试:

SELECT * FROM Tbl_Product WHERE CAST(PTime AS Date)='2012-01-20'

我会使用

SELECT * 
FROM Tbl_Product 
WHERE Year(PTime) = 2012
AND Month(PTime) = 1
AND Day(PTime) = 20

select Convert(nvarchar(10),date,101) as date from date1

这篇关于有关日期时间"SELECT QUERY"的问题吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！