Viewing 3 posts - 1 through 3 (of 3 total)
Can you take these dates and check :
@date1 = 2011-03-27 20:13:31.640
@date2 = '2011-05-27 00:00:00'
using sql server 2008
Output:
DaysHoursMinutesSeconds
6034629
can you explain me how this is correct for (hrs,mins and secs)..
May be am...
March 27, 2011 at 8:48 am
#1304061
its giving wrong results
March 27, 2011 at 7:59 am
#1304058
I need to pass two dates as input for the function..sorry i missed that part
March 27, 2011 at 3:34 am
#1304040