select * from Customer_CheckIn where status= 4 and
CheckInTime< substr(datetime(CURRENT_TIMESTAMP,'localtime'),11)||' 06:00:00'
字符串拼接 用 “||”
获取当前时间 datetime(CURRENT_TIMESTAMP,'localtime')
select * from Customer_CheckIn where status= 4 and
CheckInTime< substr(datetime(CURRENT_TIMESTAMP,'localtime'),11)||' 06:00:00'
字符串拼接 用 “||”
获取当前时间 datetime(CURRENT_TIMESTAMP,'localtime')
