On 12 July 2010 14:11, Rob Wultsch <wultsch@xxxxxxxxx> wrote: > On Mon, Jul 12, 2010 at 4:15 AM, A. Kretschmer > <andreas.kretschmer@xxxxxxxxxxxxxx> wrote: >> In response to Atul.Goel@xxxxxxxxxxxxxxxxxxx : >>> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
