| Subject | Re: Insert current time and date | 
|---|---|
| Author | Adam | 
| Post date | 2005-01-17T20:28:14Z | 
You will kick yourself
try this:
INSERT INTO MYTABLE VALUES ('MyString','NOW');
            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?