On 12 July 2010 14:11, Rob Wultsch <[email protected]> wrote: > On Mon, Jul 12, 2010 at 4:15 AM, A. Kretschmer > <[email protected]> wrote: >> In response to [email protected] : >>> Hi, >>> >>> >>> >>> I need to log the start and end time of the procedures in a table. But the >>> start and end time are same. This is how I recreated the issue. >>> >>> >>> >>> create table test_time (time timestamp); >>> >>> delete from test_time; >>> >>> insert into test_time select now(); >> >> >> Use timeofday() instead, now() returns the transaction starting time. > > > Is this part of the SQL standard? >
I don't believe it is. See http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT for more info. Thom -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
