Timestamps in specific format

[seanob86]

I’ve tried using the -t text which according to the notes uses the ISO 8601 format. However the db I am attempting to migrate uses the following format for date/time. The query below is from another sqlite db which was created by the app.

sqlite> select * from migrations;
1|2024-06-25 14:34:38.574204593+10:00|0|1|v4.38.9
2|2024-06-25 14:34:38.577114465+10:00|1|2|v4.38.9
3|2024-06-25 14:34:38.578694683+10:00|2|3|v4.38.9
4|2024-06-25 14:34:38.581398391+10:00|3|4|v4.38.9
5|2024-06-25 14:34:38.597297735+10:00|4|5|v4.38.9
6|2024-06-25 14:34:38.601760598+10:00|5|6|v4.38.9
7|2024-06-25 14:34:38.6297992+10:00|6|7|v4.38.9
8|2024-06-25 14:34:38.629993787+10:00|7|8|v4.38.9
9|2024-06-25 14:34:38.630008951+10:00|8|9|v4.38.9
10|2024-06-25 14:34:38.631153315+10:00|9|10|v4.38.9
11|2024-06-25 14:34:38.632296055+10:00|10|11|v4.38.9
12|2024-06-25 14:34:38.633191122+10:00|11|12|v4.38.9
13|2024-06-25 14:34:38.633402374+10:00|12|13|v4.38.9
14|2024-06-25 14:34:38.634327651+10:00|13|14|v4.38.9
15|2024-06-25 14:34:38.634509319+10:00|14|15|v4.38.9

The application is authelia and when I spin up the application with migrated sqlite db it appears that there is error checking on time format and fails.

Is there a way to customise the text format? For example the date command to replicate is date "+%Y-%m-%d %H:%M:%S.%N%z"