Thanks Jason and all, and apologies for posting to IBO, had submitted before
I realized it was pointed in the wrong direction!

Jason Wharton wrote:

> 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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com