Questions about using SQLite in Android

============ Problem Description ============

Query statements do not spell, please help
In the Nt_tasks table
[F_VC_JIESSJ] Datetime
[F_VC_RENWSX] CHAR (30),
The F_VC_JIESSJ field indicates when the task was received
The F_vc_renwsx field represents the time limit for a task
I'm looking for a 1-day mission to expire.

String sql = "Select T.[_id],t.[f_vc_mingc],t.[f_vc_gonglmc],t.[f_vc_jiessj],t.[state],t.[f_vc_bummc],t.[username] From Nt_tasks T "
How to spell the following query criteria

============ Solution 1============

where Julianday (strftime ('%y-%m-%d ', datetime (F_VC_JIESSJ, ' + ' | | f_vc_renwsx| | ' Day ')))
-Julianday (strftime ('%y-%m-%d ', ' Now ')) =1

Questions about using SQLite in Android