SQLite Forum

Calculating duration in ISO8601 timestamp
Login
~~~
SQLite version 3.36.0 2021-06-18 18:36:39

sqlite> select julianday('2021-07-20 15:18:26.623');
2459416.13780814
sqlite> select julianday(substr('2021-07-20 15:18:26:623',1,19)||'.'||substr('2021-07-20 15:18:26:623',21,23));
2459416.13780814
sqlite> select julianday(substr(dt,1,19)||'.'||substr(dt,21,23)) from (select '2021-07-20 15:18:26:623' as dt);
2459416.13780814
sqlite>
~~~