projects
/
emufront
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
1acc4cf
)
Time stamps in human readable format.
author
Mikko Keinänen
<mikko.keinanen@gmail.com>
Fri, 19 Nov 2010 20:43:20 +0000
(22:43 +0200)
committer
Mikko Keinänen
<mikko.keinanen@gmail.com>
Fri, 19 Nov 2010 20:43:20 +0000
(22:43 +0200)
src/db/dbfilepath.cpp
patch
|
blob
|
history
diff --git
a/src/db/dbfilepath.cpp
b/src/db/dbfilepath.cpp
index
7c6aa69
..
b77d48b
100644
(file)
--- 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 "