The argument day is not right Arguments datepart Is the part of startdate and enddate that specifies the type of boundary crossed. The following table lists all valid datepart arguments. User-defined variable equivalents are not valid. datepart Abbreviations year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww hour hh minute mi, n second ss, s millisecond ms microsecond mcs nanosecond ns

prankster · Dec 14, 2010 4:28 PM

select top 100 Shippeddate,Responsedate, CAST(DATEDIFF(DD,Shippeddate,Responsedate) AS VARCHAR)+' '+CAST(DATEDIFF(HH,Shippeddate,Responsedate) AS VARCHAR) +':'+CAST(DATEDIFF(MM,Shippeddate,Responsedate) AS VARCHAR)+':'+CAST(DATEDIFF(SS,Shippeddate,Responsedate) AS VARCHAR) +':'+CAST(DATEDIFF(MS,Shippeddate,Responsedate) AS VARCHAR) From YourTabel This might work......

BI-Polar · Dec 14, 2010 4:33 PM

I am using this syntax DATEDIFF ( datepart , startdate , enddate ) DATEDIFF(day, ShippedDate, ResponseDate) This returns the correct number of days.  If i use other arguments, say Hour    2 days = it's returning 48 I think this cannot be done with a single query. Either a Function() or Stored Procedure. Have you come across this situation? Or anyone in sajha.

Mukurdhom · Dec 14, 2010 4:43 PM

It worked !!! @Bi-Polar Thank you very much @Pransketer Thank you for your help. Just need some tuning in formating.. I can do that. Sajha has always been a great help.  Happy Tuesday !!

Mukurdhom · Dec 14, 2010 4:52 PM