Re: now() gives same time within the session

On Mon, Jul 12, 2010 at 4:15 AM, A. Kretschmer
<andreas.kretschmer@schollglas.com> wrote:
> In response to Atul.Goel@globaldatapoint.com :
>> 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@gmail.com