例子:
----日期中的查询
select * from PROCUREMENT_ITEM a ,PROCUREMENT_RESULT b
where a.procurement_item_id =b.procurement_item_id
and a.plan_code='0000002'
and '2010-10-25'<=CONVERT(CHAR(10),a.create_date, 23)
and CONVERT(CHAR(10),a.create_date, 23)<='2010-10-27
----日期中的查询
select * from PROCUREMENT_ITEM a ,PROCUREMENT_RESULT b
where a.procurement_item_id =b.procurement_item_id
and a.plan_code='0000002'
and '2010-10-25'<=CONVERT(CHAR(10),a.create_date, 23)
and CONVERT(CHAR(10),a.create_date, 23)<='2010-10-27