如何计算查询中的持续时间 [英] How to calculate duration in a query
问题描述
嗨
如果我有这样的专栏,如何计算持续时间
2008-04-19 15:00: 55.000
2008-04-19 15:01:07.000
2008-04-19 16:33:55.000
2008-04-19 16:35:07.000
2008-04-19 16:37:00.000
2008-04-19 16:37:01.000
2008 -04-19 16:37:13.000
2008-04-19 16:37:14.000
2008-04-19 16:39:35.000
2008-04-19 16:49:05.000
知道会话用户登录/注销?
SQL中的查询怎么样? br />
tq
nma
Hi
How do I clculate time duration if I have a column like this
2008-04-19 15:00:55.000
2008-04-19 15:01:07.000
2008-04-19 16:33:55.000
2008-04-19 16:35:07.000
2008-04-19 16:37:00.000
2008-04-19 16:37:01.000
2008-04-19 16:37:13.000
2008-04-19 16:37:14.000
2008-04-19 16:39:35.000
2008-04-19 16:49:05.000
to know the session user login/logout?
How is the query in SQL?
tq
nma
推荐答案
替换您的字段和表名
substitite with your field and table names
这篇关于如何计算查询中的持续时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!