房间数据库，SELECT * FROM表在给定的一天 [英] Room database, SELECT * FROM table by a given day

问题描述

我在我的Android项目中使用房间持久性库 ，并使用日期类型转换器:

I'm using Room Persistence Library in my Android project, and store date using date type converter:

object DateConverter {
    @TypeConverter
    @JvmStatic
    fun fromTimestamp(value: Long?): Date? = if (null == value) null else Date(value)

    @TypeConverter
    @JvmStatic
    fun dateToTimestamp(date: Date?): Long? = date?.time
}

如何使用推荐答案

 @Query("SELECT * FROM table_name WHERE date BETWEEN :dayst AND :dayet")
 Object getFromTable(long dayst, long dayet);

日期dayst将是00:00的时间戳，即09/11/2017 00:00:00

date dayst will be the timestamp for 00:00, i.e., 09/11/2017 00:00:00

日期dayet将是23:59的时间戳，即09/11/2017 23:59:59

date dayet will be the timestamp for 23:59, i.e., 09/11/2017 23:59:59

Object是您从数据库中获得的.

The Object is what you are getting from the database.

这篇关于房间数据库，SELECT * FROM表在给定的一天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！