diff options
-rw-r--r-- | html/index.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/html/index.php b/html/index.php index df6d4dc..3bfca3d 100644 --- a/html/index.php +++ b/html/index.php @@ -12,7 +12,7 @@ $result = $db -> query( ); $stm = $db -> prepare( - 'SELECT machines.name as machine, machines.last_update, states.name as state, "values".value' . + 'SELECT machines.name as machine, datetime(machines.last_update, "localtime") AS last_update, states.name as state, "values".value' . ' FROM machines' . ' JOIN "values" ON "values".machine_id = machines.id' . ' JOIN states ON "values".state_id = states.id' . |