title: HH:MM Format in SQL Server
body: <p>I m using a stored procedure and there i m having a column Name timespent which i want to show like HH:MM format only, the procedure is working fine but the only problem is that currently the time spent is coming as hh:mm:ss format. Guide me how i ll get time spent in HH:MM format and correct my procedure if possible.
  The procedure is like that:-</p>
  
  <pre><code>CREATE procedure St_Proc_GetUserReportforCurrentDayTask              
  @userID int              
  as              
  Begin              
      set NoCount on;              
      DECLARE @TODAY DATE                
      SET @TODAY = CONVERT(VARCHAR(10), GETDATE(), 111)              
      select CONVERT(VARCHAR,production.CalendarDate,101) + RIGHT (CONVERT(VARCHAR,production.CalendarDate , 100 ) ,7) as Date,               
      RegionAndProjectInfo.RegionProjectName as Region ,              
      County.CountyName as County,              
      WorkType.WorkTypeName as WorkType,              
      Task.TaskName as Task,  
      Production.VolumeProcessed as 'Volumes Processed',              
      Production.TimeSpent as 'Duration (HH:MM)'              
      from Production               
      inner join RegionAndProjectInfo              
      on              
      RegionAndProjectInfo.RegionProjectID=Production.RegionProjectID              
      inner join County              
      on               
      County.CountyID=Production.CountyID              
      inner join WorkType              
      on              
      WorkType.WorkTypeID=Production.WorkTypeID              
      inner join Task              
      on              
      Task.TaskID=Production.TaskID              
      where Production.UserID=@userID and CalendarDate &gt;= @TODAY              
  End 
  </code></pre>