From 8cab33fb46a0b0799269228deb3c0e3494039959 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Mikko=20Kein=C3=A4nen?= Date: Fri, 19 Nov 2010 22:43:20 +0200 Subject: [PATCH] Time stamps in human readable format. --- src/db/dbfilepath.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 " -- 1.7.9.5