Difference B/W Two Dates In SQL: What Are The Different Methods?

Asked By Toasty Guru 0 points N/A Posted on - 08/23/2016

I am doing a project related to SQL. I am stuck with the problem of how to find the difference between two dates in SQL. Which commands to use?

• Status: Open
• Question Views: 398
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Unify SQLBase

Answered By P Manson 10 points N/A #85780

Difference B/W Two Dates In SQL: What Are The Different Methods?

The DATEDIFF() returns the difference between two dates in SQL.

Syntax:

DATEDIFF(depart, start date, end date)

Example:

SELECT DATEDIFF(day, '2016-05-05', '2016-07-05') AS DiffDate

Result:

DiffDate

61

This syntax yielded result in positive. In this syntax, the first date is earlier than the second date.

Syntax:

DATEDIFF(depart, end date, start date)

Example:

SELECT DATEDIFF(day, '2016-07-05', '2016-05-05') AS DiffDate

Result:

DiffDate

-61

This syntax yielded result in negative. In this syntax, the first date is afterward that of the second date.

About P Manson

Questions
2

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/23/2016
• Question Category: Unify SQLBase