Re: localtime(0)

On 12/29/2014 08:32 AM, Suresh Raja wrote:

Hi:

I'm using localtime(0) in various part of the function, and updating
table with the time. I use localtime at places like the start of the
function and at the end of the function. The function takes about 5 mins
to run,.  The issue is that the function always print the same time for
both start and end.  I'm trying to capture the time at various point of
the function, but it always print the same time.  Is localtime(0) is not

See:

http://www.postgresql.org/docs/9.3/interactive/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

In particular clock_timestamp()

correct.

Thanks,
-SR

--
Adrian Klaver
adrian.klaver@aklaver.com