Time Data Type

The following rules apply to the table column values of time data type:

A string representation of time is a string that starts with a digit, and has a length of at least 4 characters.
Leading blanks are not valid.
Trailing blanks are included.
Leading zeros are omitted in the hour part of the time and seconds can be omitted entirely. If you omit seconds, zero seconds is assumed. Thus 13.30 is equivalent to 13.30.00.

Format Name	Abbreviation	Time Format	Example
International Standards Organization	1 ISO1	hh.mm.ss	13.30.05
IBM USA standard	USA	hh:mm AM or PM	1:30 PM
IBM European standard	EUR	hh.mm.ss	13.30.05
Japanese industrial standard Christian era	JIS	hh:mm:ss	13:30:05

Note: 1. This is an earlier version of the ISO format. JIS can be used to get the current ISO format.

The following rules apply for the USA format:

The minutes can be omitted by specifying 00 minutes. For example, 1 PM is equivalent to 1:00 PM.
The letters A, M, and P can be lower case.
A single blank must precede the AM or PM.

The hour must not be greater than 12 and cannot be 0 except for the special case of 00:00 AM.