34,591
社区成员
发帖
与我相关
我的任务
分享
select * from t1 where 时间 >= '2010-5-10'
select * from t1 where CONVERT(varchar,时间,120) >= '2010-5-10'
----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-05-09 11:24:08
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
-- Jul 9 2008 14:43:34
-- Copyright (c) 1988-2008 Microsoft Corporation
-- Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
-- Blog : http://blog.csdn.net/htl258
----------------------------------------------------------------------------------
--> 生成测试数据表: [tb]
IF OBJECT_ID('[tb]') IS NOT NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb] ([time] [nvarchar](20))
INSERT INTO [tb]
SELECT '2010-5-6' UNION ALL
SELECT '2010-5-7' UNION ALL
SELECT '2010-5-8' UNION ALL
SELECT '2010-5-10' UNION ALL
SELECT '2010-5-11'
SELECT * FROM [tb]
-->SQL查询如下:
select * from tb where CONVERT(datetime,[time]) >= '2010-5-10'
select * from tb where cast([time] as datetime) >= '2010-5-10'
/*
time
--------------------
2010-5-10
2010-5-11
(2 行受影响)
*/
select * from t1 where CONVERT(datetime,时间) >= '2010-5-10'