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