> Do you mean like this?
>
> `2021-07-19T08:43:46.956+0800`
You're missing a colon:
```
$ sqlite3
sqlite> select julianday('2021-07-19T08:43:46.956+0800');
sqlite> select julianday('2021-07-19T08:43:46.956+08:00');
2459414.53040458
```
The timezone format is specified in [](https://sqlite.org/lang_datefunc.html#time_values).