Store dates using local time instead of UTC

(closes issue #11610, reported and patched by rbraun_performatique)

git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@94548 65c4cc65-6c06-0410-ace0-fbb531ad65f3

diff --git a/res/res_config_sqlite.c b/res/res_config_sqlite.c
index 473622b..fb22009 100644 (file)
--- a/res/res_config_sqlite.c
+++ b/res/res_config_sqlite.c
@@ -557,9 +557,9 @@ static char *sql_add_cdr_entry =
 "      '%q',"
 "      '%q',"
 "      '%q',"
-"      datetime(%d,'unixepoch'),"
-"      datetime(%d,'unixepoch'),"
-"      datetime(%d,'unixepoch'),"
+"      datetime(%d,'unixepoch','localtime'),"
+"      datetime(%d,'unixepoch','localtime'),"
+"      datetime(%d,'unixepoch','localtime'),"
 "      '%ld',"
 "      '%ld',"
 "      '%ld',"