How to SQL Format seconds as HH:MM:SS time

See more:

SQL

SQL-Server-2012

How to SQL Format seconds as HH:MM:SS time

this query .....

select distinct
E.USERID,
(select min(Convert (TIME,TIMESTAMPS)) from access_event_logs As MINCE
where CAST(MINCE.TIMESTAMPS as DATE)=CAST(E.TIMESTAMPS As DATE) AND MINCE.EVENTID ='In' and MINCE.USERID=E.USERID) as InTime,
(select max(Convert(TIME,TIMESTAMPS)) from access_event_logs As MAXCE
where CAST(MAXCE.TIMESTAMPS as DATE)=CAST(E.TIMESTAMPS As DATE) AND MAXCE.EVENTID ='Out' and MAXCE.USERID=E.USERID) as OutTime
from access_event_logs As E
WHERE E.USERID='012' AND Convert(date,LOCALTIMESTAMP) between '03/2/2014' and '03/02/2014'

output:
012 08:34:29.0000000 14:23:29.0000000


so iwant timestamp i need like this hh:mm or hh:mm:ss