Re: localtime(0)

Try clock_timestamp() or timeofday()::timestamp
http://www.postgresql.org/docs/9.3/static/functions-datetime.html

2014-12-29 10:31 GMT-06:00 Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>:

> 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
> correct.
>
> Thanks,
> -SR
>
>

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/