如何查询显示时间不超过30分钟的记录

Question

我想查询过去30分钟内的记录。

                        String CREATE_FOJ_TABLE = "CREATE TABLE " + TABLE_FOJ
            + "(" + KEY_FOJID + " INTEGER PRIMARY KEY," + KEY_FOJPICKUPPOINT
            + " TEXT," + KEY_FOJDESTINATION + " TEXT," + KEY_FOJPICKUPTIME
             + KEY_FOJFARES + " TEXT," + 
                            KEY_FOJSPECIAL
            + " TEXT," +KEY_FOJVIA + 
                         " TEXT," + KEY_FOJMILAGE
            + " TEXT" + ")";

    ////////     this is my query //////////////
                    String selectQuery = "SELECT  * FROM " + TABLE_FOJ +" ORDER BY "+ 
         KEY_FOJPICKUPTIME;

Answer 1

试试这个：适用于MySQL

SELECT * FROM TABLE_NAME WHERE your_timestamp_columnname BETWEEN timestamp(DATE_SUB(NOW(), INTERVAL 30 MINUTE)) AND timestamp(NOW())