各位高手，求一条SQL语句？？急！！

[航宇]

我有一个表，表中有一个DateTime类型字段RiQ，
我想查找出日期等2004-4-25的所有记录，请问这条SQL语句怎写？？

[jeke342]

select * from table where year(riq)=2004 and month(riq)=4 and day(riq)=25

不知道行不行.. 我不是很懂.. 呵呵

[航宇]

难道没有更好的办法吗？

[scapple]

select * from table where TO_DAYS(RiQ) = TO_DAYS('2004-04-25');

月份必须写成这样“2004-04-25”

[嬉皮]

select * from table where DATE_FORMAT(RiQ,'%Y-%c-%e')=DATE_FORMAT('2004-4-25','%Y-%c-%e')

[hbzyduwu]

select * from table where DATE_FORMAT(riq,'%Y-%m-%d') = '2004-4-25'

[loveflea]

select * from table where TO_DAYS(RiQ) = TO_DAYS('2004-4-25');