The following CREATE TABLE statement defines a PERIOD(TIME(6)) column since the precision defaults to 6.
CREATE TABLE t8 ( job_id INTEGER, job_desc CHARACTER(15), job_status CHARACTER(1), job_hours PERIOD(TIME));
The following CREATE TABLE statement defines a PERIOD(TIME(6)) column since the precision defaults to 6.
CREATE TABLE t8 ( job_id INTEGER, job_desc CHARACTER(15), job_status CHARACTER(1), job_hours PERIOD(TIME));