Re: [SQL ] 請教MSSQL datetime只取出時間做篩選

[daniel1205 (艾琳是我最愛的人!!)]

其實寫法有很多~

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