lundi 8 juin 2015

how to convert 9/6/2015 6:25:48 AM --> 2015-06-09 in sqlite

how to get result in sqlite? 9/6/2015 6:25:48 AM to this format 2015-06-09

SELECT strftime('%d-%m-%Y', usertable.startTime) FROM usertable

Aucun commentaire:

Enregistrer un commentaire