Formatting a timestamp

Remember that SQLite does not have a real 'time' datatype. You have to use a number or text. If you decide to use a timestamp, you can format it like this:

 

SELECT strftime('%m/%d/%Y %H:%M ', datetime(1332513000, 'unixepoch'))