From 69d3016beff218901324cc5bae5fe9e5ca13cec3 Mon Sep 17 00:00:00 2001 From: Eric Lippmann Date: Thu, 17 Nov 2016 12:41:12 +0100 Subject: [PATCH] ido-pgsql: Use timestamp without time zone in from_unixtime and to_timestamp functions refs #13221 --- lib/db_ido_pgsql/schema/pgsql.sql | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) diff --git a/lib/db_ido_pgsql/schema/pgsql.sql b/lib/db_ido_pgsql/schema/pgsql.sql index 5601a1fa7..e082ae3b5 100644 --- a/lib/db_ido_pgsql/schema/pgsql.sql +++ b/lib/db_ido_pgsql/schema/pgsql.sql @@ -10,12 +10,14 @@ -- Functions -- -CREATE OR REPLACE FUNCTION from_unixtime(bigint) RETURNS timestamp with time zone AS ' - SELECT to_timestamp($1) AS result -' LANGUAGE sql; - -CREATE OR REPLACE FUNCTION unix_timestamp(timestamp with time zone) RETURNS bigint AS ' - SELECT EXTRACT(EPOCH FROM $1)::bigint AS result; +DROP FUNCTION IF EXISTS from_unixtime(bigint); +CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ + SELECT to_timestamp($1) AT TIME ZONE 'UTC' AS result +$$ LANGUAGE sql; + +DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE); +CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ' + SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result; ' LANGUAGE sql; -- 2.40.0