From: marc tobias <mtmail@gmx.net>
Date: Wed, 14 Mar 2018 15:42:41 +0000 (+0100)
Subject: remove the 2-minute offset hack from data date in HTML output
X-Git-Tag: v3.2.0~108^2
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/d23fa84471a92664431775fdfa81048180d3f359

remove the 2-minute offset hack from data date in HTML output
---

diff --git a/website/details.php b/website/details.php
index 4c4ce578..24e8cd76 100755
--- a/website/details.php
+++ b/website/details.php
@@ -231,7 +231,7 @@ if ($oParams->getBool('keywords')) {
 logEnd($oDB, $hLog, 1);
 
 if ($sOutputFormat=='html') {
-    $sSQL = "SELECT TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' FROM import_status LIMIT 1";
+    $sSQL = "SELECT TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' FROM import_status LIMIT 1";
     $sDataDate = chksql($oDB->getOne($sSQL));
     $sTileURL = CONST_Map_Tile_URL;
     $sTileAttribution = CONST_Map_Tile_Attribution;
diff --git a/website/reverse.php b/website/reverse.php
index 6df90029..2f1e31ee 100755
--- a/website/reverse.php
+++ b/website/reverse.php
@@ -72,7 +72,7 @@ if (CONST_Debug) {
 }
 
 if ($sOutputFormat == 'html') {
-    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));
+    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));
     $sTileURL = CONST_Map_Tile_URL;
     $sTileAttribution = CONST_Map_Tile_Attribution;
 }
diff --git a/website/search.php b/website/search.php
index 346f5b57..0dddacce 100755
--- a/website/search.php
+++ b/website/search.php
@@ -66,7 +66,7 @@ $hLog = logStart($oDB, 'search', $oGeocode->getQueryString(), $aLangPrefOrder);
 $aSearchResults = $oGeocode->lookup();
 
 if ($sOutputFormat=='html') {
-    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));
+    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));
 }
 logEnd($oDB, $hLog, sizeof($aSearchResults));