Try the following command, all on one line. I've attached my output...
$ echo "select usUnits,datetime(dateTime,'unixepoch','localtime'),dateTime,inTemp,outTemp,inTemp-outTemp
from archive order by rowid desc limit 5;" | sqlite3 /home/weewx/archive/weewx.sdb
1|2023-03-05 10:45:00|1678041900|73.0|43.3|29.7
1|2023-03-05 10:40:00|1678041600|73.0|44.3|28.7
1|2023-03-05 10:35:00|1678041300|73.1|44.5|28.6
1|2023-03-05 10:30:00|1678041000|73.3|44.2|29.1
1|2023-03-05 10:25:00|1678040700|73.5|43.9|29.6
If you see a '1' in the first column, you are using US units. A 16 or 17 there is metric with the only difference being which units wind speed is in.