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