我想要SQL数据功能 [英] i want sql data function

问题描述

先生我制作了物业网站...首先我们销售情节，情节是销售全额付款和laon ....

一个情节是成本10000任何人想通过这个情节贷款...所以我们拿钱..通过（EMI）

............................ ...........................就像这...............

CUSTOMER NAME .............................. ANUJ

客户ID ..... ................................. 1

客户给予....... .......... 10000 ....

客户第一个EMI日期..............（6-11-2015）

............................................ ..................................................

现在我们想要下个月的EMI日期..



但是问题是每个月的日子......有些月份是30天30多天是28或29

如何计算下个月的EMI日期..





我使用ASP，NET和SQL SERVER以及C＃LANGUAGE。

sir i making property website so...first we sale plot ,,plot is sale full payment and laon....
one plot is cost 10000 any person want to by this plot by loan...so we take money ..through (EMI)
.......................................................LIKE THIS...............
CUSTOMER NAME..............................ANUJ
CUSTOMER ID......................................1
CUSTOMER GIVE AMOUNT ...............10000....
CUSTOMER FIRST EMI DATE..............(6-11-2015)
..............................................................................................
NOW WE WANT NEXT MONTH DUE EMI DATE..

BUT PROBLEM IS MONTH DAYS ..SOME MONTH IS 30 DAYS SOME 31 AND FEB IS 28 OR 29
SHO HOW CAN CALCULATE DUE EMI DATE FOR NEXT MONTH..


I USING ASP,NET AND SQL SERVER AND C# LANGUAGE.

推荐答案

它很简单。



只需在你的第一个EMI日期加一个月，然后计算下个月的EMI日期。就像

Its very simple.

Just add one month to your first EMI date and calculate the next month EMI date. Just like

select dateadd(m,1,getdate())

DATEADD（）函数从日期添加或减去指定的时间间隔。

The DATEADD() function adds or subtracts a specified time interval from a date.

DATEADD(datepart,number,date)

这篇关于我想要SQL数据功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！