sql 时间类型 like 查询

select * FROM ShopNum1_Address
WHERE
convert(varchar(50),CreateTime,120) LIKE '2011-07-13%'