今天同学问我这个该怎么处理,我觉得对它进行转换:
WITH
T1
AS
(
Select Convert ( DateTime ,( ' 2011-6-10 ' + CONVERT ( varchar ( 100 ), 登记时间, 24 ))) AS 时间, * From [ 采购_使用计划 ]
)
Select T1. * FROM T1
Where 时间 Between ' 2011-6-10 09:00:00 ' AND ' 2011-6-10 10:00:00 '
(
Select Convert ( DateTime ,( ' 2011-6-10 ' + CONVERT ( varchar ( 100 ), 登记时间, 24 ))) AS 时间, * From [ 采购_使用计划 ]
)
Select T1. * FROM T1
Where 时间 Between ' 2011-6-10 09:00:00 ' AND ' 2011-6-10 10:00:00 '
本文转自齐师傅博客园博客,原文链接:http://www.cnblogs.com/youring2/archive/2011/06/20/2085498.html,如需转载请自行联系原作者