Subject Re: [firebird-support] Insert current time and date
Author Gary Benade
> 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);