حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

SQL Server: Find total days between two Dates

Adnaan

Adnaan

SOLVED CLOSED ACTIVE ANSWERED
User: Adnaan
Posted: 16 hours ago
Forum: SQL Server
Answer: 1
Views: 36

Hi,

I want to determine the difference in Days i.e. total days between two dates in SQL Server.

Please guide

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

Mudassar

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: 16 hours ago
Report

You can use DATEDIFF function and pass parameter as DAY to it to get difference in Days.

SELECT DATEDIFF(DAY, '2025-02-07', '2025-02-10')

or

SELECT DATEDIFF(DAY, '2025-02-07', GETDATE())

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.