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'))

Add a Comment...

 

Comments

LloydBeeb Chile DBNViolet RoslynvnK Arsenal Mercedesf AlisaPff Kroatien EfrenLore EverettDe Manchester City TrishaHen JudithKas Uruguay CornellGr ElvinGraf Olympique De Marseille EJKKisha AugustusF Uruguay AngelikaS AugustusF Uruguay AngelikaS EzraReich Inter Milan DillonRaw ColetteBo Osterrike Valeriewb - 3/07/2017