Re: localtime(0)

clock_timestamp() gives more than I need. i just need time, - no date, or
msec or timezone. How can i get to print the current time alone.

Thanks,

On Mon, Dec 29, 2014 at 10:41 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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
>