查询出生日期的疑问


直接上图...怎么查询出来的内容都是空的?无论我把日期范围调成多少都是空的
[解决办法]

select * from student where symd between '1900-1-1' and '1999-1-2'

select * from student where symd between '1900-01-01' and '1999-01-02'