Re: localtime(0) - Mailing list pgsql-general

From Adrian Klaver
Subject Re: localtime(0)
Date
Msg-id 54A18452.7010007@aklaver.com
Whole thread Raw
In response to localtime(0)  (Suresh Raja <suresh.rajaabc@gmail.com>)
Responses Re: localtime(0)
List pgsql-general
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Rollback on include error in psql
Next
From: David Johnston
Date:
Subject: Re: Rollback on include error in psql