解决方案 select * from tb_student where to_char(start_date,'mm')=7 参考 http://blog.csdn.net/flyhaze/article/details/3457597