From 5d36546a994258a66ad9758e4583907def9e3f89 Mon Sep 17 00:00:00 2001 From: Michael Friedrich Date: Mon, 17 Sep 2018 09:51:20 +0200 Subject: [PATCH] Ensure to use UTC timestamps for IDO PgSQL cleanup queries refs #6584 --- lib/db_ido_pgsql/idopgsqlconnection.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/db_ido_pgsql/idopgsqlconnection.cpp b/lib/db_ido_pgsql/idopgsqlconnection.cpp index 9771d4027..16e0b567d 100644 --- a/lib/db_ido_pgsql/idopgsqlconnection.cpp +++ b/lib/db_ido_pgsql/idopgsqlconnection.cpp @@ -947,7 +947,7 @@ void IdoPgsqlConnection::InternalCleanUpExecuteQuery(const String& table, const Query("DELETE FROM " + GetTablePrefix() + table + " WHERE instance_id = " + Convert::ToString(static_cast(m_InstanceID)) + " AND " + time_column + - " < TO_TIMESTAMP(" + Convert::ToString(static_cast(max_age)) + ")"); + " < TO_TIMESTAMP(" + Convert::ToString(static_cast(max_age)) + ") AT TIME ZONE 'UTC'"); } void IdoPgsqlConnection::FillIDCache(const DbType::Ptr& type) -- 2.40.0