From: Mikko Keinänen <mikko.keinanen@gmail.com>
Date: Fri, 19 Nov 2010 20:43:20 +0000 (+0200)
Subject: Time stamps in human readable format.
X-Git-Url: http://vcs.maemo.org/git/?p=emufront;a=commitdiff_plain;h=8cab33fb46a0b0799269228deb3c0e3494039959

Time stamps in human readable format.
---

diff --git a/src/db/dbfilepath.cpp b/src/db/dbfilepath.cpp
index 7c6aa69..b77d48b 100644
--- a/src/db/dbfilepath.cpp
+++ b/src/db/dbfilepath.cpp
@@ -114,7 +114,7 @@ QString DbFilePath::constructSelect(QString where) const
 {
     return QString("SELECT filepath.id AS FilePathId, "
             "filepath.name AS Name, "
-            "filepath.lastscanned AS LastScanned, "
+            "datetime(filepath.lastscanned, 'unixepoch') AS LastScanned, "
             "setup.id AS SetupId, "
             "platform.name || ' ' || mediatype.name AS SetupName, "
             "filepath.filetypeid "