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