Subject Re: [ib-support] INSERT VALUES question
Author Jason Wharton
Try it in single quotes. Also, 'NOW' and 'TODAY' should work too.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Lee Catlett" <lee@...>
To: <>
Sent: Wednesday, December 20, 2000 2:42 PM
Subject: [ib-support] INSERT VALUES question

> I am trying to place some test data into a new table that has a timestamp
> field.
> Is it possible to use this format in some fashion?
> CREATE TABLE whatever (
> docID varchar(30) NOT NULL,
> title varchar(64) NOT NULL,
> ...
> etc.
> ...
> last_modified timestamp);
> INSERT INTO whatever VALUES (1,'Store Name',. .etc . . , timestamp);
> I can't get timestamp to work and can't seem to find any documentation as
> whether it's valid to use it in this fashion. Any help appreciated.
> Lee Catlett