gettime() - a timeofday() alternative

From: Brendan Jurd <direvus(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: gettime() - a timeofday() alternative
Date: 2005-08-07 06:10:17
Message-ID: 37ed240d05080623101d1094a1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi all,

I propose to add an internal function gettime() that transparently
returns the current system time, as a timestamptz with maximum
precision.

Calling gettime() would be a more elegant approach than calling
timeofday() and converting it to a timestamp, and avoids some of the
potential problems in that conversion (such as "Sat" being
misinterpreted as an Australian timezone).

I'm open to alternate suggestions for the name of the function.

If there are no objections, I'll start cooking up a patch right away.

--
BJ

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2005-08-07 12:46:08 obtaining row locking information
Previous Message Jim Buttafuoco 2005-08-07 01:23:28 Re: unexpected pageaddr on startup/recovery

Browse pgsql-patches by date

  From Date Subject
Next Message Satoshi Nagayasu 2005-08-07 23:07:05 Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Previous Message Luke Lonergan 2005-08-07 05:21:03 Re: COPY FROM performance improvements