作者daniel1205 (艾琳是我最爱的人!!)
看板Database
标题Re: [SQL ] 请教MSSQL datetime只取出时间做筛选
时间Wed Aug 4 01:42:46 2010
其实写法有很多~
WHERE CONVERT(varchar(7),timeT,111) = '2010/03'
AND DATEPART(hour,timeT) BETWEEN 7 AND 10
或者
WHERE timeT BETWEEN '2010/03/01' AND '2010/03/31'
AND DATEPART(hour,timeT) BETWEEN 7 AND 10
: SELECT *
: FROM 资料库
: where
: year(timeT)=2010
: and
: month(timeT)=3
: and
: (
: ( datapart(hour,timeT)>=7 and datapart(hour,timeT)<=9)
: or
: (datapart(hour,timeT)=10
: and
: datapart(minute,timeT)=0
: and
: datapart(second,timeT)=0)
: )
: Enjoy~
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.168.130.227