dimanche 17 janvier 2016

SQLITE datetime for different timzone required, not only localtime

I want to fetch date and time, in different timezones using SQLITE. Say, I get the value as, 20160118T010856 in input, but I require it to change to Australian, England and other timezones. What I am currently able to do is : select datetime('2016-01-18T04:13:39','localtime'); Which only provides me for my currnet local time. Kindly help.

Aucun commentaire:

Enregistrer un commentaire