数据库查询！！！！

Question

表text       shijian
2009-12-17 13:38:30
2009-12-18 14:38:30
2009-12-19 15:38:30
2009-12-19 15:38:30
2009-12-19 16:38:30
2009-12-19 17:38:30
2009-12-19 18:38:30我想查出 2009-12-19日的总数

Answer 1

SELECT COUNT(*) FROM SHIYAN WHERE [字段]='2009-12-19'
ps:你没给出字段，最好加一个数据类型转换

Answer 2

打错了，顺便给你转型吧
SELECT COUNT(*) FROM SHIJIAN WHERE datepart([字段])='2009-12-19'

Answer 3

select count(*)
from text
where datediff(day,shijian,'2009-12-19')=0

Answer 4

这样也可以
select count(*)
from text
where convert(nvarchar(10),shijian,120)='2009-12-19')

Answer 5

select count(*)
from text
where convert(nvarchar(10),shijian,120)='2009-12-19'

Answer 6

select *
from test
where datediff(day,shijian,'2009-12-19')=0

Answer 7

我日 你那叫总数吗select *
from text 
where convert(nvarchar(10),shijian,120)='2009-12-19'

Answer 8

select * from text where shijian>'2009-12-19 00:00:00' and shijian<'2009-12-20 00:00:00'

Answer 9

表达式中 'convert' 函数未定义

Answer 10

select * from text where shijian>'2009-12-19 00:00:00' and shijian <'2009-12-20 00:00:00' 这个没用么