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?