RT
表名:A
时间字段:ddatetime(datetime类型)
查询2003-2004年6月7日-7月8日数据。
1
select * from A where (extract(year from ddatetime) between 2003 and 2004)
2and (extract(month from ddatetime) between 6 and 7)
3and (extract(day from ddatetime) between 6 and 7)
extract只能取到日。小时，或者到秒，需要to_char。
查询2003-2004年6月7日-7月8日12时到20时数据。
1select * from A where (extract(year from ddatetime) between 2003 and 2004)
2and (extract(month from ddatetime) between 6 and 7)
3and (extract(day from ddatetime) between 6 and 7) and (to_char(ddatetime,'HH24') between 12 and 20)
以上查询在oracle可运行。
posted on 2009-01-18 14:12
rapin 阅读(2901)
评论(4) 编辑 收藏 所属分类:
数据库