在存储过程中怎么获得时间差？

[限量的蓝天]

CREATE PROC [dbo].[PWork]
@Date1 VARCHAR(20),
@Date2 VARCHAR(20),
@OperId int
AS

declare @DiffDate int
--------------------------
set @DiffDate=select datediff(DAY,@Date1,@Date2) 出错

select datediff(DAY,@Date1,@Date2) into @DiffDate 也出错

该怎么获得select datediff(DAY,@Date1,@Date2)的结果啊？

[阳泉酒家小当家]

改成这样试试： CREATE PROC [dbo].[PWork] @Date1 VARCHAR(20), @Date2 VARCHAR(20), @OperId int AS declare @DiffDate int -------------------------- set @DiffDate= datediff(DAY,@Date1,@Date2)

[發糞塗牆]

alter PROC [dbo].[PWork]
@Date1 VARCHAR(20),
@Date2 VARCHAR(20),
@OperId int
AS

declare @DiffDate int 

select @DiffDate= datediff(DAY,@Date1,@Date2)

[mkinglife]

楼主传递的什么参数啊？ sql里手动赋值是正确的。。。

[發糞塗牆]

set 和select不能在一起

[發糞塗牆]

http://blog.csdn.net/dba_huangzj/article/details/8503028

[KeepSayingNo]

楼主这样试试

declare @DiffDate int 

select @DiffDate =datediff(DAY,@Date1,@Date2)

select @DiffDate