这是我的表格。
TIME Status
2012-11-15 8:30:00.000 "WAS_FLOW"
2012-11-15 9:00:00.000 "WAS_FLOW"
2012-11-15 10:30:00.000 "H2_FLOW"
2012-11-11 12:14:00.00 "O23HZ_FLOW"
2012-11-11 8:00.00.000 "AZ_FLOW"
2012-11-12 9:00.000 "BZ_FLOW"
我希望我的结果显示:
TIME "WAS FLOW"
2012-11-11 0
2012-11-12 0
2012-11-15 2
LEFT(time, 10)
替代DATEADD
计算。 - MatBailie