接下来的15天 [英] get next 15 days' date

问题描述

我今天有约会。但我必须得到接下来的15天日期并在gridview中显示它。那么如何获得接下来的15天日期？

i搜索了Adddays（）用于那个但它不起作用。

i have today date.but i have to get next 15 days date and display it in gridview.So how to get next 15 days date ?
i have search that Adddays() is used for that ,but it is not working.

SqlCommand cmd = new SqlCommand("select * from birthdays where DOB=''"+ DateTime.Today.AddDays(15)+"''",cnn);

i试试这个，但我的数据集是空的（不显示任何记录）。

i have try this but my dataset is empty(not display any record).

推荐答案

无耻插件： TimeRanger - 允许在一个时间间隔内进行预告 [ ^ ]

CREATE FUNCTION [dbo].[GetLatest10Dates1](
 
@mydate datetime
)
RETURNS
@tbl table (mydate datetime)
AS
BEGIN
 -- Declare the return variable here
 declare @i int =0
while(@i < 15)
begin
insert into @tbl(mydate)
select @mydate+@i
set @i = @i+1
end
 -- Return the result of the function
 RETURN
 
END

///////////////////////// /////////////////////////////////////

你可以看到结果喜欢

//////////////////////////////////////////////////////////////
you can see the result like

Declare @dat date
set @dat='2013-01-01'

Declare @tbl table (mydate datetime,rn int)
     insert into @tbl(mydate,rn)
(Select *, row_number() over (order by mydate ) as m  From dbo.GetLatest10Dates1(cast(@dat as date)))
select * from @tbl

这篇关于接下来的15天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！