From 897ffe5e29ab022d75ad948ecf894e0a3ed3b2f5 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期二, 04 三月 2025 18:01:41 +0800 Subject: [PATCH] fix: 1 --- app/src/main/java/com/example/firstapp/model/DailyStat.kt | 9 +++++---- 1 files changed, 5 insertions(+), 4 deletions(-) diff --git a/app/src/main/java/com/example/firstapp/model/DailyStat.kt b/app/src/main/java/com/example/firstapp/model/DailyStat.kt index 5cd26c6..0f2d8d8 100644 --- a/app/src/main/java/com/example/firstapp/model/DailyStat.kt +++ b/app/src/main/java/com/example/firstapp/model/DailyStat.kt @@ -4,13 +4,14 @@ @DatabaseView( """ - SELECT date(createtime/1000, 'unixepoch', 'localtime') as date, + SELECT substr(createtime, 1, 10) as date, COUNT(*) as count FROM code - GROUP BY date(createtime/1000, 'unixepoch', 'localtime') + GROUP BY substr(createtime, 1, 10) """ ) data class DailyStat( val date: String, - val count: Int -) \ No newline at end of file + val count: Int, + val week_start: String? = null +) \ No newline at end of file -- Gitblit v1.9.3