SQL语句，请各位大大帮忙，小弟在线等！急........

[chmz]

在表中有这样一些字段：
ssn,wo,fail_time,fail_station,id

现在的问题是怎样用SQL语句把fail_time为：01/01/00 00:00:00的数据选出来？

[klan]

如果你的fail_time不是datetime类型的
select * from yourTable where fail_time='01/01/00 00:00:00'

否则
select * from yourTable where fail_time='2000-01-01 00:00:00'

[gmlxf]

select * from yourTable where fail_time='01/01/00 00:00:00'

[khyhli]

select * from yourtable where convert(varchar(8),fail_time,112)='20000101'

[lvltt]

select * from table where fail_time = Convert(DateTime,'01/01/00 00:00:00')

[erigido]

select * from yourTable where fail_time='01/01/00 00:00:00'

[chmz]

如果不是datetime类型，能不能用 :order by fail_time or group by fail_time?

[gmlxf]

如果不是datetime类型，能不能用 :order by fail_time or group by fail_time?
-------------
group by可以
但是order by就不准确了

你建立字段的时候，你的字段fail_time定义datetime为好些，统计排序都方便。

[leeboyan]

如果fail_time字段设置默认值为getdate()
1.先在查询分析器里执行：
select * from table where (fail_time>='01/01/00 00:00:00' and fail_time<='01/01/00 00:00:00')
查询结果为例：fail_time为01/01/00 00:00:00.125
2.再执行select * from table where (fail_time='01/01/00 00:00:00.125'）即可