2. SQL Data Types : Data Types : Time Data Types
 
Share this page                  
Time Data Types
The TIME data type consists of a time in hour, minutes, seconds, optional fractions of a second, and optional time zone.
The format is as follows:
TIME [time_precision] [time_zone_spec]
time_precision
(Optional) Indicates the number of digits of precision in the fractions of seconds, as an integer value from 0 to 9. When no time precision is supplied, the value of time_precision is set to 0 by default.
Note:  When a value is entered that exceeds the specified precision, the value is truncated at the specified precision.
time_zone_spec
(Optional) Specifies a time zone as one of the following:
WITH TIME ZONE
WITHOUT TIME ZONE
WITH LOCAL TIME ZONE
Note:  The time value in TIME WITH TIME ZONE data type indicates the time at the specified time zone.
Examples:
Time Format
Example
TIME(5) WITH TIME ZONE
12:30:55.12345-05:00
TIME(4) WITHOUT TIME ZONE
12:30:55.1234
TIME(9) WITH LOCAL TIME ZONE
12:30:55.123456789