diff options
| author | Erich Eckner <git@eckner.net> | 2022-08-03 20:21:29 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2022-08-03 20:21:29 +0200 |
| commit | 277f54106bf098235e0a3ce709b3adc7a1130276 (patch) | |
| tree | 563f3f2feef221533f7009fbd514845e17f80b57 | |
| parent | 9f76db63dd8abbe478b3539719475d467e2a5bb6 (diff) | |
| download | colocation-277f54106bf098235e0a3ce709b3adc7a1130276.tar.xz | |
| -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' . |