Adam wrote:

> --- In firebird-support@yahoogroups.com, Hans <hhoogstraat@...> wrote:
>> I did test, and unfortunately current_timestamp doesnt change :)
>>
>
> What version and dialect are of Firebird are you running?
>
>>From Firebird 1.5.3 Dialect 3
>
> Using iSQL:
> ---
>
> SQL> select current_timestamp from RDB$DATABASE;
>
> CURRENT_TIMESTAMP
> =========================
>
> 2006-10-09 15:32:13.0000
>
> SQL> select current_timestamp from RDB$DATABASE;
>
> CURRENT_TIMESTAMP
> =========================
>
> 2006-10-09 15:32:15.0000
>
> SQL>
>
>
> ---
>
> They look pretty different to me.
>
> Note that I executed the query:
>
> select current_timestamp from RDB$DATABASE;
>
> then paused for a two seconds, pressed the up arrow and pressed enter.
>
> Obviously if you run a script with both of them it will almost always
> give you the same time for both.
>
> Adam
>

I guess that ISQL do autocommit for you...

Regards
Boguslaw