转换一下即可： sqlserver: select * from tab where convert(varchar(10),datecol,120) between '2013-04-15' and '2013-05-04' oracle select * from tabxxx where to_char(datecol,'yyyy-mm-dd') between '2013-04-15' and '2013-05-04'
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024