From d685417fbb8692d5ddee8ce60fc80e6b228c81bf Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 4 Apr 2003 04:50:44 +0000 Subject: Avoid repeated computation of the constants date2j(1970, 1, 1) and date2j(2000, 1, 1). Should make for some marginal speed improvement in date/time operations. --- src/backend/utils/adt/pgstatfuncs.c | 13 +------------ 1 file changed, 1 insertion(+), 12 deletions(-) (limited to 'src/backend/utils/adt/pgstatfuncs.c') diff --git a/src/backend/utils/adt/pgstatfuncs.c b/src/backend/utils/adt/pgstatfuncs.c index 787f0226cdc..083bb1374a4 100644 --- a/src/backend/utils/adt/pgstatfuncs.c +++ b/src/backend/utils/adt/pgstatfuncs.c @@ -328,18 +328,7 @@ pg_stat_get_backend_activity_start(PG_FUNCTION_ARGS) if (sec == 0 && usec == 0) PG_RETURN_NULL(); - /* - * This method of converting "Unix time" (sec/usec since epoch) to a - * PostgreSQL timestamp is an ugly hack -- if you fix it, be sure to - * fix the similar hackery in timestamp.c - */ -#ifdef HAVE_INT64_TIMESTAMP - result = (((sec - ((date2j(2000, 1, 1) - date2j(1970, 1, 1)) * 86400)) - * INT64CONST(1000000)) + usec); -#else - result = (sec + (usec * 1.0e-6) - ((date2j(2000, 1, 1) - - date2j(1970, 1, 1)) * 86400)); -#endif + result = AbsoluteTimeUsecToTimestampTz(sec, usec); PG_RETURN_TIMESTAMPTZ(result); } -- cgit v1.2.3