X-Git-Url: http://vcs.maemo.org/git/?a=blobdiff_plain;f=src%2Fdb%2Fdbfilepath.cpp;h=b77d48b095abbd5dce0584a8b1cd74659e340e6d;hb=8cab33fb46a0b0799269228deb3c0e3494039959;hp=7c6aa69dc6e202582e43dcbb31f379fb09ceb66a;hpb=1acc4cf18f1e4e38a514b7de816d9b04c44fb6e2;p=emufront

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 "