求救：在存储过程中，怎么根据输入的时间段 判断是几天啊？

Question

比如 输入的参数是 2007-01-01  2007-02-05，怎么得出这一段时间的天数？

Answer 1

select datediff(day,'2007-01-01','2007-02-05')

Answer 2

declare @dt_startdatetiem datetime,@dt_enddatetime datetime
select  @dt_startdatetiem='2007-01-01',@dt_enddatetime='2007-02-05'
select datediff(day,@dt_startdatetiem,@dt_enddatetime)

Answer 3

select datediff(dd,'2007-01-01','2007-02-05')

Answer 4

create proc get_day @dt_startdatetiem datetime,@dt_enddatetime datetime
as
select datediff(day,@dt_startdatetiem,@dt_enddatetime)-----显示相差多少天-----
exec get_day '2007-01-01','2007-02-05'

Answer 5

select datediff(dd,'2007-01-01','2007-02-05')