jeudi 26 novembre 2015

current_timestamp and datetime() with DST in SQLite

I'm writing an app for Android and want to support different locales. I'm trying to use current_timestamp and datetime('now') of SQLite, but not sure if I need to put my own additional calculations for DST with them. I thought I had to, but datetime('now', 'localtime') seems to do a calculation already so confused now and want to make sure if it really is.

Does SQLite deal with daylight saving automatically?

PS. current_timestamp and datetime('now') are the exactly same things? Always the same values and no performance issues at all?

Aucun commentaire:

Enregistrer un commentaire