show ISO dates and not timestamps

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@238 8392b6e1-25fa-0310-8288-cc32f8e212ea

diff --git a/sql/backups_full.sql b/sql/backups_full.sql
index 0eca72a..b26818f 100644 (file)
--- a/sql/backups_full.sql
+++ b/sql/backups_full.sql
@@ -4,10 +4,10 @@ select
        hosts.name as host,
        shares.name as share,
        backupnum as num,
-       backups.date as backup_date,
+       abstime(backups.date) as backup_date,
        backups.type as type,
-       min(files.date) as from,
-       max(files.date) as to,
+       abstime(min(files.date)) as from,
+       abstime(max(files.date)) as to,
        count(*) as files,
        sum(files.size) as size,
        sum(backups.size) as backup_size