select * from table where year(columndate)=year(currentdate) and month(columndate)=month(currentdate) and day(columndate)=day(currentdate)
如果就要查当然的话,那currentdate=getdate()
SELECT * FROM TABLE
WHERE to_char(column_Date,'yyyymmddhh24mmss') > '20030423000000' //FROM_DATE
AND to_char(column_Date,'yyyymmddhh24mmss') < '20030423115959' //END_DATE