Miscellaneous#
SQLite#
Formatting UNIX time in SQLite#
SELECT strftime("%F %R:%f", 1713213002.456, "unixepoch", "subsecond");
In SQLite, the strftime
function formats the 2nd argument (time value) according the
1st argument (the format). The modifiers are from the 3rd argument onwards,
"unixepoch"
indicates that the time value shall be interpreted as UNIX epoch, and
the "subsecond"
modifiers indicates the time value has millisecond in it, hence
the time value is a float instead of an int.