in my SQLite database, I have a time field with minutes, seconds, and centiseconds:
00:01:100
I want to select the row with the MAX value in milliseconds and I fount the strftime function. I'm trying with:
SELECT MAX(strftime("%M:%S:%SSS", field)) FROM table;
But it doesn't works.
Aucun commentaire:
Enregistrer un commentaire