How to use datetime difference in SQL Select? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to use datetime difference in SQL Select?

Message

From

20/03/2009 17:46:29

Sergey Berezniker
New York, United States

To

20/03/2009 17:20:20

Dmitry Litvak
Massachusetts, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: How to use datetime difference in SQL Select?

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01390159

Message ID:

01390174

Views:

65

This message has been marked as a message which has helped to the initial question of the thread.

SELECT SUM(CAST(DATETIME1 - DATETIME2 AS int))  AS NUMDAYS

>
>How do you SUM number of days difference between two DateTime type fields as following:
>
>

>select SUM( DATETIME1 - DATETIME2) AS NUMDAYS
>

--sb--

Click here to load this message in the networking platform