diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-04-04 04:50:44 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-04-04 04:50:44 +0000 |
| commit | d685417fbb8692d5ddee8ce60fc80e6b228c81bf (patch) | |
| tree | 2946cb557c8c40cc312a455355f35188a1460ad5 /src/backend/utils/adt/pgstatfuncs.c | |
| parent | 3b4ca4c0d9dd5807013a8404fc8283219f21f93b (diff) | |
| download | postgresql-d685417fbb8692d5ddee8ce60fc80e6b228c81bf.tar.gz postgresql-d685417fbb8692d5ddee8ce60fc80e6b228c81bf.zip | |
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.
Diffstat (limited to 'src/backend/utils/adt/pgstatfuncs.c')
| -rw-r--r-- | src/backend/utils/adt/pgstatfuncs.c | 13 |
1 files changed, 1 insertions, 12 deletions
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); } |