diff options
Diffstat (limited to 'unscoop.c')
| -rw-r--r-- | unscoop.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/unscoop.c b/unscoop.c index 4392816..033c1dd 100644 --- a/unscoop.c +++ b/unscoop.c @@ -263,8 +263,8 @@ static void prepareInsert(void) { SELECT // SQLite expects a colon in the timezine, but ISO8601 does not. CASE WHEN :time LIKE '%Z' - THEN datetime(:time) - ELSE datetime(substr(:time, 1, 22) || ':' || substr(:time, -2)) + THEN strftime('%s', :time) + ELSE strftime('%s', substr(:time, 1, 22) || ':' || substr(:time, -2)) END, :type, context, names.name, :target, :message FROM contexts, names |