一个简单的sql怎么写？

[flamefiredelphi]

一个表中有个datetime类型字段
想取出2002.7.1号到2003.6.30号的数据，该怎么写sql语句。
字段名同意为riqi

[jiezhi]

select * from a where datetime between to_date('2002/06/30','yyyy/mm/dd') and to_date('2002/07/01','yyyy/mm/dd')

[flamefiredelphi]

select * from datetime
where riqi between to_date('2003/06/30/00/00/00','yyyy/mm/dd/hh24/mi/ss') and to_date('2003/06/30/23/59/59','yyyy/mm/dd/hh24/mi/ss')
order by riqi;
更准确一些吧
比如有2002/07/01 00:00:00的数据的话，楼上的也会select 出来

[hdkkk]

select * from a where trunc(datetime) between between to_date('2002/06/30','yyyy/mm/dd') and to_date('2002/07/01','yyyy/mm/dd')

[flamefiredelphi]

这个还差不多