--- 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