DATE: 4 Bytes (All Platforms) |
1Year |
1Month |
Day |
AD January 1, 1 — AD December 31, 9999 |
TIME: 6 Bytes (Packed64 Platforms) 8 Bytes (Aligned Row Platforms) |
|
Hour |
Minute |
Seconds |
hh:mm:ss[.ssssss] |
12 Bytes (Aligned Row Platforms) TIMESTAMP: 10 Bytes (Packed64 Platforms) |
|
Year |
Month |
Day |
Hour |
Minute |
Second |
yyyy-mm-dd hh:mm:ss |
TIME WITH TIME ZONE: 8 Bytes (All Platforms) |
Hour |
Minute |
Second |
Timezone_Hour |
Timezone_Minute |
hh:mm:ss.ssssss±hh:mm |
TIMESTAMP WITH TIME ZONE: 12 Bytes (All Platforms) |
Year |
Month |
Day |
Hour |
Minute |
Second |
Timezone_Hour |
Timezone_Minute |
yyyy-mm-dd hh:mm:ss±hh:mm |
The following table indicates the alignment requirements for each of the ANSI/ISO DateTime data types and their respective sizes on packed64 and aligned row platforms. When the size of a stored value for a type differs for packed64 and aligned row platforms, the differing table cells are shaded.
Data Type |
Packed64 Size (bytes) |
Aligned Row Size (bytes) |
Allocated Aligned Row Size (bytes) |
DATE |
4 |
4 |
4 |
TIME |
6 |
4 |
8 |
TIMESTAMP |
10 |
4 |
12 |
TIME WITH TIME ZONE |
8 |
4 |
8 |
TIMESTAMP WITH TIME ZONE |
12 |
4 |
12 |