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?