ShippedDate='2010-10-03 07:08:25.780
Calculate date Difference = (ShippedDate - ResponseDate)
= 1 01:03:12:660
1 = number of days
01 = Hours
03 = Minutes
12=Seconds
660= Milliseconds
My Query
SELECT
ResponseDate
,ShippedDate
,DATEDIFF
(
day
, ShippedDate, ResponseDate)
AS
DateDifference
This query returns only number of days.
Any gurus here in Sajha. Please help me.
Read Full Discussion Thread for this article