vendredi 30 octobre 2015

SQLite and STRFTIME

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