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