datatime
在sql中如何通过代码实现时间的比较，例如判断变量是否处于2006-1-1与2006-2-1这个时间段内。谢谢了。 问题点数：20、回复次数：3Top
1 楼amandag（高歌）回复于 2006-06-02 19:48:28 得分 0
select * from [表] where [时间字段] between '2006-1-1' and '2006-2-1'Top
2 楼sanjie88（菜鸟依旧,谁动了我的毛片）回复于 2006-06-02 21:25:08 得分 0
select * from [表] where [时间字段] between cast('2006-1-1' as datetime) and cast('2006-2-1' as datetime)
===================================
我觉得这样比较保险Top
3 楼chcky（成浩）回复于 2006-06-02 22:49:36 得分 0
ACCESS数据库：select * from [表] where [时间字段] between #2006-1-1# and #2006-2-1#
SQL数据库：select * from [表] where [时间字段] between '2006-1-1' and '2006-2-1'
Top
