如何计算自记录条目以来的天数?安卓、SQLite、Java [英] How do I calculate days since a record entry? Android, SQLite, Java

问题描述

我有一个包含存储日期字段的数据库.我希望能够计算记录日期和今天之间的天数.

我最终使用了:

<前>mDb.execSQL("更新"+DATABASE_PLANTS_TABLE+"设置"+ KEY_PLANT_DAYS+" = (SELECT julianday('now') - julianday("+KEY_DATE+") FROM"+ DATABASE_PLANTS_TABLE+")");

解决方案

select (strftime('%s','now')-strftime('%s', data1))/86400.0 as days from table

I have a database with a field for a stored date. I would like to be able calculate the days between the recorded date and today.

I ended up using:

mDb.execSQL("UPDATE "+DATABASE_PLANTS_TABLE+" SET "+ KEY_PLANT_DAYS+ 
            " = (SELECT julianday('now') - julianday("+KEY_DATE+") FROM"+ DATABASE_PLANTS_TABLE+")");

解决方案

select (strftime('%s','now')-strftime('%s', data1))/86400.0 as days from table

这篇关于如何计算自记录条目以来的天数?安卓、SQLite、Java的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！