[code=SQL]select * from tb month([date])=5 and datepart([date]) between 1 and 12 and [date] between convert(varchar(10),[date],120)+' 20:30:00' and convert(varchar(10),[date],120)+' 23:59:00'[/code]
select * from 销售表 where (销售日期 between '2011-05-01' and '2011-05-12') and (substring(convert(varchar(20), 销售日期, 121), 12, 8) between '20:30' and '23:59')
WITH CTE AS ( SELECT CONVERT(varchar(100),FTIME,23) AS D1,CONVERT(varchar(100),FTIME,24) AS D2,* FROM T_ORDER ) SELECT * FROM CTE WHERE D1 BETWEEN '2011-05-01' AND '2011-05-12' AND D2 BETWEEN '20:30:00' AND '23:59:00'
SELECT * FROM 销售记录表 WHERE [date] >= '20110501' AND [date] < '20110513' AND CONVERT(CHAR(5), [date], 114) >= '20:30'
select * from 销售表 where (销售日期 between '2011-05-01' and '2011-05-12') and convert(varchar(8), 销售日期, 108) between '20:30' and '23:59'
datepart([date]) between 1 and 12 and
[date] between convert(varchar(10),[date],120)+' 20:30:00'
and convert(varchar(10),[date],120)+' 23:59:00'[/code]
select * from 销售表
where (销售日期 between '2011-05-01' and '2011-05-12') and (substring(convert(varchar(20), 销售日期, 121), 12, 8) between '20:30' and '23:59')
WITH CTE AS
(
SELECT CONVERT(varchar(100),FTIME,23) AS D1,CONVERT(varchar(100),FTIME,24) AS D2,* FROM T_ORDER
)
SELECT * FROM CTE WHERE D1 BETWEEN '2011-05-01' AND '2011-05-12' AND D2 BETWEEN '20:30:00' AND '23:59:00'
WHERE [date] >= '20110501' AND [date] < '20110513'
AND CONVERT(CHAR(5), [date], 114) >= '20:30'
where (销售日期 between '2011-05-01' and '2011-05-12') and convert(varchar(8), 销售日期, 108) between '20:30' and '23:59'