Home Forums SQL Server 2005 SQL Server 2005 General Discussion how to calculate Time Diff RE: how to calculate Time Diff

  • 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