SQLite Forum

(Deleted)
Login
Say 


`SELECT julianday('2021-01-02 01:00:00')-julianday('2021-01-01 04:00:00')
`
1 day and 3 hours will be 1.125 days

= 2459216.5416666665 - 2459215.6666666665 = 0.875 = julianday

How to transfer this 'julianday' back to **days**? 

For example, 10 days and 6 hours will be 10.25 days

EDIT: Better explanation