How to remove Date from output? I have a query which gives the output as shown below.

SELECT *,
       DATEADD(SECOND, ( DATEDIFF(SECOND, InTime, OutTime) ), 0) AS Total
FROM   TableXYZ




EmpName InTime  OutTime DayStart    NameOfMonth YearSet Total
ABC 12:11:32    21:53:24    Day1    November    2016    1/1/00 9:41
DEF 12:05:56    21:20:58    Day1    November    2016    1/1/00 9:15


I tried to remove date from Total but doesn't work. how can I do that and get the output below?

EmpName InTime  OutTime DayStart    NameOfMonth YearSet Total
ABC 12:11:32    21:53:24    Day1    November    2016    9:41
DEF 12:05:56    21:20:58    Day1    November    2016    9:15
As you are working with SQL Server 2014 you could cast/convert as a time (started in SQL 2008)

SELECT *,
cast(DATEADD(SECOND, ( DATEDIFF(SECOND, InTime, OutTime) ), 0) as time(0)) AS Total
FROM   TableXYZ