The datatype TIMESTAMP, which extends the datatype DATE, stores the year, month, day, hour, minute, and second. The syntax is:TIMESTAMP[(precision)] where the optional parameter precision specifies the number of digits in the fractional part of the seconds field. You cannot use a symbolic constant or variable to specify the precision; you must use an integer literal in the range 0 .. 9. The default is 6.The default timestamp format is set by the Oracle initialization parameter NLS_TIMESTAMP_FORMAT.In the following example, you declare a variable of type TIMESTAMP, then assign a literal value to it:DECLARE checkout TIMESTAMP(3); BEGIN checkout := '1999-06-22 07:48:53.275'; ... END; In this example, the fractional part of the seconds field is 0.275.
试试CREATE TABLE test(
testID NUMBER(10, 0) NOT NULL,
test_Date TIMESTAMP(7)
);
where the optional parameter precision specifies the number of digits in the fractional part of the seconds field. You cannot use a symbolic constant or variable to specify the precision; you must use an integer literal in the range 0 .. 9. The default is 6.The default timestamp format is set by the Oracle initialization parameter NLS_TIMESTAMP_FORMAT.In the following example, you declare a variable of type TIMESTAMP, then assign a literal value to it:DECLARE
checkout TIMESTAMP(3);
BEGIN
checkout := '1999-06-22 07:48:53.275';
...
END;
In this example, the fractional part of the seconds field is 0.275.
CREATE TABLE test(
testID NUMBER(10, 0) NOT NULL,
test_Date TIMESTAMP(6)
);
表已创建
或
CREATE TABLE test1(
testID NUMBER(10, 0) NOT NULL,
test_Date TIMESTAMP
)
表已创建