jeudi 23 avril 2015

SQLite convert milliseconds to HH:MM:SS

based on the SQLite documentation, there is time() that is equivalent with strftime('%H:%M:%S', ...). SO i tested it with my query

time(time)

but after run the query, all the result become 12:00:00

the data is basically in milliseconds (25000, 5000, 15000)

What is the problem??

Aucun commentaire:

Enregistrer un commentaire