日期比较语句的写法?

[xiaofenguser]

日期比较,象这样
select * from main where '1'='1' and up_time in(2001-01-01,2002-12-31)
和
select * from main where '1'='1' and up_time>2001-01-01 and up_time<2002-12-31
得不到正确结果,在JSP中执行,请帮忙指正!!

[natfit]

select * from main where '1'='1' and (up_time between '2002-12-31' and '2001-01-01' )

[奇遇]

select * from main where '1'='1' and up_time>#2001-01-01# and up_time<#2002-12-31#
or
select * from main where '1'='1' and (up_time between #2001-01-01# and #2002-12-31#)

[xiaofenguser]

OK,已经解决了, inalover(奇遇)的正确!