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