Each datetime data type has its own means for determining the length of the value and for knowing what information is stored, such as day, month, minutes, seconds, fraction of a second, etc.

Every column in a table has a name and a data type. The data type tells DB2 how much physical storage to set aside for the column and the form in which the data are stored. DB2 uses IBM SQL data types ...