English 中文(简体)
添加甲状腺素数据库中的时间长度
原标题:Add up sum of time in android SQLite database

I have a database that time stamps every five minutes, or less if the user stops the database. How can I take the sum of the difference between the time stamps and add them up?

http://www.ohchr.org。

我有六次不同的时间,每五分钟五分五分钟,而一次,只有两分钟时间,而最后的汽车时间被用户拖了:

13:41:33

13:46:33

1351:33

13:56:33

14:01:33

14:06:33

14:08:27

我现在要谈谈过去历时多分钟的一点:

13:41:33 = 0 / / 将成为零原因,即用户开始时间

13:46:33 = 5

1351:33 = 5

页: 1

14:01.33 = 5

14:06.33 = 5

页: 1

之后,我请求听取所有五位和两党的意见,并补充:

0+

5 +

5 +

5 +

5 +

5 +

2 =

27分钟

最佳回答

利用<代码>SUM在该栏中发挥作用,并给你以结果。 你也许应该把问题与更具体的标签(SQLite,QLQ, Ec)联系起来。

问题回答

暂无回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签