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? -- Rob Wultsch wultsch@xxxxxxxxx -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
