สร้างตาราง tbtest

create table tbtest
(
    id          SERIAL  PRIMARY KEY,
    firstname   varchar(50) NOT NULL,
    date1 DATE,
    date3 datetime year to fraction(3),
    date5 datetime year to fraction(5),
    timestamp   DATETIME YEAR TO FRACTION(5) DEFAULT SYSDATE YEAR TO FRACTION(5) 
);