Plz need help in time manipulation.

• Jitendra Jangid

  SSC Rookie

  Points: 37

  More actions

  February 6, 2013 at 6:35 am

  #288716

  Hi guys,

  I have used DateDiff build-in function :exclamation:of sql server to get time difference in HH but facing some problem. I don't know why it's happening so:

  SELECT DATEDIFF(HH,CAST('15:58:00.0000000' as TIME),CAST('16:02:00.0000000' as TIME))

  Returns: 1 Hours

  the difference between these two time is around 4 min so, query should return 0 hours but it's returning 1. I don't know why?

  So, please anybody come-up with some explanation why is this happening.

  Regards,

  Jangid

• kiril.lazarov.77

  Hall of Fame

  Points: 3742

  More actions

  February 6, 2013 at 7:01 am

  #1584934

  Try

  SELECT (DATEDIFF(SECOND,CAST('15:03:00.0000000' as TIME),CAST('16:02:00.0000000' as TIME))/3600)

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 6, 2013 at 7:56 am

  #1584958

  Here is a good reference on how DATEDIFF works: http://www.sqlteam.com/article/datediff-function-demystified.