Subject | Re: [firebird-support] Insert current time and date |
---|---|
Author | Gary Benade |
Post date | 2005-01-17T22:02:49Z |
> I want to write an insert statement that inserts a string and theYou could try INSERT INTO MYTABLE VALUES ('MyString', current_time);
> 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?