如何将SQL格式化为HH：MM：SS时间 [英] How to SQL Format seconds as HH:MM:SS time

问题描述

如何将SQL格式化为HH：MM：SS时间



此查询.....

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'

输出：

012 08：34：29.0000000 14 ：23：29.0000000





所以我需要这样的时间戳hh：mm或hh：mm：ss

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


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

推荐答案

尝试这种方法。



select convert（varchar（100），GETDATE（），108）

Try this method.

select convert(varchar(100),GETDATE(),108)

SELECT convert(varchar,GETDATE(),108)

SQL中的日期时间格式

这篇关于如何将SQL格式化为HH：MM：SS时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！