Query to use DateDiff in SQL Server

rakibxl

SOLVED CLOSED ACTIVE ANSWERED
User: rakibxl
Posted: on Oct 23, 2018 05:00 AM
Forum: SQL Server
Answer: 1
Views: 1811

I have a vb.net datediff code look below

BlobSmartWorkingContract.MonthDuration = DateDiff(DateInterval.Month, New Date(BlobSmartWorkingContract.ContractStartDate.Value.Year, BlobSmartWorkingContract.ContractStartDate.Value.Month, 1), New Date(BlobSmartWorkingContract.ContractEndDate.Value.Year, BlobSmartWorkingContract.ContractEndDate.Value.Month, 1).AddMonths(1))

i want to do as it is in sql server anybody can help me please

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Oct 23, 2018 05:01 AM
Report

Hi rakibxl,

Refer below query.

SQL

SELECT DATEDIFF(MONTH,'2017/10/1',DATEADD(MONTH,1,'2018/10/1'))

Output

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Query to use DateDiff in SQL Server

Company

Explore

Follow us

Contact Us