Store dates using local time instead of UTC
authorMark Michelson <mmichelson@digium.com>
Fri, 21 Dec 2007 20:38:18 +0000 (20:38 +0000)
committerMark Michelson <mmichelson@digium.com>
Fri, 21 Dec 2007 20:38:18 +0000 (20:38 +0000)
(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

res/res_config_sqlite.c

index 473622b..fb22009 100644 (file)
@@ -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',"