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(dot)klaver(at)aklaver(dot)com