how to calculate Time Diff

• 2M

  SSC-Addicted

  Points: 485

  More actions

  June 23, 2015 at 11:26 pm

  #147340

  hello,

  I have used below conversion for date-time to find time from date.

  LTRIM(RIGHT(Convert(VARCHAR(20), PGL.[In-Time],100),7))as In_Time,

  LTRIM(RIGHT(Convert(VARCHAR(20), PGL.[Out-Time],100),7)) as Out_Time

  Now I have to calculate time difference? How can I do it?

  please suggest...

  Reply awaited..

• doug.brown

  SSCertifiable

  Points: 5608

  More actions

  June 23, 2015 at 11:54 pm

  #1807624

  You can use DATEDIFF for time as well as dates. No need for the conversion - just DATEDIFF(second/minute/hour, In-Time, Out-Time)

  https://msdn.microsoft.com/en-us/library/ms189794.aspx

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  June 24, 2015 at 12:10 am

  #1807627

  what i understand from your question is that you are looking for the Time portion from the datetime field.

  DateTime: 24-Jun-2015 12:45:35.000

  and your are looking for

  '12:45:35.000' only.

  check the following link