Subject Re: Insert current time and date
Author Adam
You will kick yourself

try this:

INSERT INTO MYTABLE VALUES ('MyString','NOW');


--- In firebird-support@yahoogroups.com, "ra8009" <ra8009@y...> 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?