摘要: selECT julianday( datetime('2015-01-05 00:00:00') )- julianday( strftime('%Y-%m-%d %H:%M:%S',recordDate ) ) from weather julianday()函数精确到秒,所以要 添加Time小 阅读全文