在线等待,简单问题:between时间段问题 select * from tablename where timename between '2011-7-9 00:00' and '2011-7-9 18:00'怎么发现10点之前的数据查不到呢各位大侠帮我看看怎么回事? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from tablename where timename between '2011-07-09 00:00' and '2011-07-09 18:00' select * from tablename where timename between '2011-07-09 00:00' and '2011-07-09 18:00' select * from tablename where timename between '2011-7-9 00:00' and '2011-7-9 18:00'--你确定在这时间段有数据? select * from tablename where timename between '2011-07-09 00:00' and '2011-07-09 18:00'把时间标准化,我已经试过了,反而查不出任何数据,因为数据库里全是2011-7-5 9:57:21这样的格式 insert into @TableName(Col1,timename)values ('a','2011-7-9 9:50:50') ,('b','2011-7-9 8:50:50') ,('c','2011-7-9 10:50:50') ,('d','2011-7-9 11:50:50') ,('e','2011-7-9 12:50:50') ,('f','2011-7-9 13:50:50') ,('f','2011-7-9 18:50:50') select * from @TableName where timename between '2011-7-9 00:00' and '2011-7-9 18:00' see the above sql result is correct or not, sorry that I did not setup a Chinese input software yet. 我查到问题了,数据库的timename的格式是nvarchar(50)。那么如果不改变数据库的字段类型,那么怎么写sql语句呢 select * from tablename where convert(datetime,timename) between '2011-07-09 00:00' and '2011-07-09 18:00' sql条件选择语句 嵌套事务回滚报错 请问日文字符显示问题 sql server 开发版 备份数据库的 菜鸟问个sql文 请教一SQL语句 在存储过程中进行判断的问题,一定给分! 怎么设计数据库去存储某条信息的可能有多个值的属性 大量数据更新出错 求教SQL语句,具体见帖子内容,谢谢。 请问这个报表 的Sql 写法 有没有规范点的?
between '2011-7-9 00:00' and '2011-7-9 18:00'--你确定在这时间段有数据?
把时间标准化,我已经试过了,反而查不出任何数据,因为数据库里全是2011-7-5 9:57:21这样的格式
values ('a','2011-7-9 9:50:50')
,('b','2011-7-9 8:50:50')
,('c','2011-7-9 10:50:50')
,('d','2011-7-9 11:50:50')
,('e','2011-7-9 12:50:50')
,('f','2011-7-9 13:50:50')
,('f','2011-7-9 18:50:50')
select * from @TableName
where timename between '2011-7-9 00:00' and '2011-7-9 18:00'
那么如果不改变数据库的字段类型,那么怎么写sql语句呢
where convert(datetime,timename) between '2011-07-09 00:00' and '2011-07-09 18:00'