On Mon, Jul 12, 2010 at 06:11:31AM -0700, Rob Wultsch 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? > No, see section 9.9.4 of the manual. Cheers, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
