Re: problem with timeofday() function in cvs PostgreSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: problem with timeofday() function in cvs PostgreSQL
Date
Msg-id 26568.1060355168@sss.pgh.pa.us
Whole thread Raw
In response to Re: problem with timeofday() function in cvs PostgreSQL  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-general
Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
>> You probably want now() instead of that function.

> I can't use now() or others because I need actual time in transaction.

Just cast the result of timeofday() to timestamp (with time zone, likely).

            regards, tom lane

pgsql-general by date:

Previous
From: Martin Hart
Date:
Subject: strategies for optimising common lookups etc
Next
From: "Eric Anderson Vianet SAO"
Date:
Subject: unexpected chunk number