Try it in single quotes. Also, 'NOW' and 'TODAY' should work too.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Lee Catlett" <lee@...>
To: <IB-support@egroups.com>
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
to
> whether it's valid to use it in this fashion. Any help appreciated.
> Lee Catlett