vendredi 5 juin 2015

How can i convert datetime to date format in sqlite selected vaues

I just try to convert datetime to date. but it was not success. help me to do it

select date('startTime') from usertable ;

select datetime(substr(startTime, 7, 4 )) from usertable;

Aucun commentaire:

Enregistrer un commentaire