From e9db716b26e49a36d733d5e224280fb63943fb9f Mon Sep 17 00:00:00 2001 From: Michael Friedrich Date: Wed, 11 Jan 2017 17:34:09 +0100 Subject: [PATCH] Ensure that PostgreSQL timestamps are UTC fixes #13617 --- 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 f398fda50..c16f9f50f 100644 --- a/lib/db_ido_pgsql/idopgsqlconnection.cpp +++ b/lib/db_ido_pgsql/idopgsqlconnection.cpp @@ -636,7 +636,7 @@ bool IdoPgsqlConnection::FieldToEscapedString(const String& key, const Value& va } else if (DbValue::IsTimestamp(value)) { long ts = rawvalue; std::ostringstream msgbuf; - msgbuf << "TO_TIMESTAMP(" << ts << ")"; + msgbuf << "TO_TIMESTAMP(" << ts << ") AT TIME ZONE 'UTC'"; *result = Value(msgbuf.str()); } else if (DbValue::IsTimestampNow(value)) { *result = "NOW()"; -- 2.40.0