Posted by: Mukurdhom December 14, 2010
Login in to Rate this Post:
0
?
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.