At 04:36 PM 20-12-00 -0500, you wrote:

>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.

Timestamp is a data type, not a variable. Use a date literal - e.g. 'NOW'
will give you the server timestamp. There is a variable CURRENT_DATE too,
but someone else would need to tell you whether it includes the time.

The documentation you want is the Data Definition Guide, one of the books
of the IB 6 documentation set. You can download the beta version from the
site in my sig, go to the documentation page.

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________