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