From 277f54106bf098235e0a3ce709b3adc7a1130276 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 3 Aug 2022 20:21:29 +0200 Subject: give time in localtime --- html/index.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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' . -- cgit v1.2.3-54-g00ecf