_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 讌一危一BETWEEN

Contents

1


1 #

create table #temp
(
	begin_dt datetime
,	end_dt datetime
)

insert #temp
select '2010-01-19 00:00:00.000', '2010-01-19 10:51:06.640'
union all
select '2010-01-18 10:51:06.640', '2010-01-18 11:51:06.640'
union all
select '2010-01-18 10:51:06.640', '2010-01-19 10:51:06.640'

--殊 20100118 朱.. 
select * from #temp
where 1=1
and begin_dt < '20100119'
and end_dt >= '20100118'

企蟆 讌(DD)螳 /覿/豐 危 蟾讌 一一 伎 蟆曙 '20100118' between begin_dt and end_dt 螳 譟郁唄 蟇碁 20100118 讌 一危磯ゼ 覈 螳語れ . 豺蠍 暑..
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

轟 轟 螳 襦 伎 . ( 覦襴)