Thanks, very interesting discussion.

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > > I want to write an insert statement that inserts a string and the
> > > current time into a table:
> > >
> > > INSERT INTO MYTABLE VALUES ('MyString',NOW);
> > >
> > > The SQL above doesn't work, it says that "NOW" isn't recognized.

What

> > > is the right way to do this?
> >
> > You could try INSERT INTO MYTABLE VALUES ('MyString', current_time);
>
> yes and just be aware, current_time is fixed to the start of the

transaction

> in which it is being used, versus 'NOW' which is fresh to the

statement in

> which it is being used
> Alan