Seems silly, but I’ve been using SQLite and was having the darnedest time try to convert an integer into a time. Problem was, I knew the functions for Sqlite3 had to be out there, but all I kept getting from search engines and exploring the developer Wiki were the C/C++ API functions, not the ones needed for SQL. I guess the way the pages are indexed, the source pages score higher than the user manual pages.
Anyhow, located the SQL functions and wanted to document their location for myself so I could locate them again later.
Seems they are called Core Functions.
I was thrilled to find that the SQLite C Interface allowed the creation of your own functions. Brilliant!
Turns out, that the date and time functions were hiding in a different part on the Wiki.
The magic I wanted, given a time stored in an integer, was:
SELECT datetime(timevalue, 'unixepoch', 'localtime');