diff options
| author | Stefan Sperling <ssperling@sysmocom.de> | 2018-01-22 18:27:25 +0100 |
|---|---|---|
| committer | Harald Welte <laforge@gnumonks.org> | 2018-01-23 16:57:52 +0000 |
| commit | 3b26f3495054196d42ac94fe4683aa94564807d8 (patch) | |
| tree | c6a00da52a77f5be5ed066cdf570051eb1470d32 | |
| parent | b8c0cf8d09477fa864ba09bf490e26ed7bacaec0 (diff) | |
Fix value of stored SMS validity time.
Quote the argument to sqlite's datetime(). Otherwise, the timestamp
stored in the database reads back as a negative value for some reason.
Before:
1032 validity_timestamp = dbi_result_get_datetime(result, "valid_until");
(gdb) p validity_timestamp
$2 = -1516814654
After:
1032 validity_timestamp = dbi_result_get_datetime(result, "valid_until");
(gdb) p validity_timestamp
$2 = 1516814654
Change-Id: Icf786f9b1efabfe7407fb6414ec0d326d8f7244a
| -rw-r--r-- | src/libmsc/db.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/libmsc/db.c b/src/libmsc/db.c index 4bf9b1f08..b48d137c5 100644 --- a/src/libmsc/db.c +++ b/src/libmsc/db.c @@ -711,7 +711,7 @@ int db_sms_store(struct gsm_sms *sms) "user_data, text, " "dest_addr, dest_ton, dest_npi, " "src_addr, src_ton, src_npi) VALUES " - "(datetime('%lld', 'unixepoch'), datetime(%lld, 'unixepoch'), " + "(datetime('%lld', 'unixepoch'), datetime('%lld', 'unixepoch'), " "%u, %u, %u, " "%u, %u, %u, " "%u, " |