select * from bs_child_baseinfo t WHERE to_char(birthday,'yyyymmdd')='20180313' 转载于:https://www.cnblogs.com/cgy-home/p/11268733.html