日期比较语句怎么写?

[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

都得不到正确结果,请帮帮忙!!!

[liudong963]

这好像与数据库有关的啊。

[xiaofenguser]

ACCESS的数据库,ODBC连接的.
query="select * from main where '1'='1' and up_time between to_date('2001-01-01','yyyy-mm-dd') and to_date('2002-12-31','yyyy-mm-dd')";
也不行

[xiaofenguser]

帮忙,帮忙!!!!!!!!!!!!!!

[zxhong]

select * from main where 字段名（如果是字符型）='1' （如果是整型）=1 and up_time>'2001-01-01' and up_time<'2002-12-31'
//''一定要加上

[liudong963]

试试这样啊：
query="select * from main where '1'='1' and up_time >=#2001-01-01# and up_time <=#2002-12-31#";

但up_time字段一定要是时间日期型啊。

[soloxiao]

一样的:
query="select * from main where '1'='1' and up_time between #2001/01/01# and #2002/12/31#";

[tomatowitch]

query="select * from main where '1'='1' and up_time between #2001/01/01/00/00# and #2002/12/31/00/00#";