我数据表有一字段time 类型是datetime
里面有数据 2006-01-12 12:12:13
2006-01-14 10:12:22
2006-01-16 09:10:50我用这条语句select time from biao where time like '2006-01-14%';
有2006-01-14 10:12:22这条数据
但是我用select time from biao where time like '2006-01%';
2006-01-14 10:12:22这条数据丢失
然后我换个方式select time from biao where time>'2006-01-01 00:00:00' and time<='2006-01-16 23:59:59';还是丢失,好奇怪啊!1
里面有数据 2006-01-12 12:12:13
2006-01-14 10:12:22
2006-01-16 09:10:50我用这条语句select time from biao where time like '2006-01-14%';
有2006-01-14 10:12:22这条数据
但是我用select time from biao where time like '2006-01%';
2006-01-14 10:12:22这条数据丢失
然后我换个方式select time from biao where time>'2006-01-01 00:00:00' and time<='2006-01-16 23:59:59';还是丢失,好奇怪啊!1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货