jeudi 13 août 2015

Sqlite with Substr to catch parts of strings

Lets suppose that we have this value inside a row 23/06/2014 01:57:44 PM and we need to catch only the number 06, for this I try the code below:

substr(aRow, 3, -18)

Is correct?

Aucun commentaire:

Enregistrer un commentaire