Subject | INSERT VALUES question |
---|---|
Author | Lee Catlett |
Post date | 2000-12-20T21:42:19Z |
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
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