dimanche 8 novembre 2015

SQLite DateTime format functions return null

I have a table with a datetime filed that i want to extract only the time in the above format

HH:MM:SS

i tryed using time() and strftime() functions but when the value of minutes is less than 10 it returns null.

Thanks a lot for your help in advance

Aucun commentaire:

Enregistrer un commentaire