SQL 的日期比较可以用<,> a符号
SQL 如下:
declare @return as int
if (select convert(varchar(100),getdate(),120))>'2011-9-10 15:38:26'
begin
set @return =1
end
else
begin
set @return=2
end
select @return
sqlserver的
declare @return as int
if (select convert(varchar(100),getdate(),120))>'2011-9-10 15:38:26'
set @return =1
else
set @return=2
select @return
然后你只要取到这个变量值 就可以了
SELECT 'datetime'=
CASE
WHEN DATEDIFF(day, '2011-9-10 15:38:26', getdate()) > 0 THEN 1
ELSE 2
END
FROM tablename
使用 case when then else
select
case when convert(varchar(19),getdate(),20)>'2011-9-10 15:38:26' then 1 else 2 end
select (case when getdate()>'2011-8-11 15:38:26' then 1 when getdate()<'2011-8-11 15:38:26' then 2 end) as '大小'