Great and important topic of DB2 Date/Time/Timestamp. Reference IBM.
|DATE||A date is a three-part value representing a year, month, and day in the range of 0001-01-01 to 9999-12-31.|
|TIME||A time is a three-part value representing a time of day in hours, minutes, and seconds, in the range of 00.00.00 to 24.00.00.|
|TIMESTAMP||A timestamp is a seven-part value representing a date and time by year, month, day, hour, minute, second, and microsecond, in the range of 0001-01-01-00.00.00.000000000 to 9999-12-31-24.00.00.000000000 with nanosecond precision. Timestamps can also hold timezone information|
Data Type Memory in DB2
- DB2 Date – takes 4 bytes.
- DB2 Time – 3 bytes.
- DB2 Timestamp – It takes 10 bytes.
DB2 – Timestamp with timezone: The format is
For example: 2011-05-19.10.19.00.000000-5:00
If you do not enter a value for a TIMESTAMP WITH TIME ZONE column, Optim uses the current DB2 SESSION TIME ZONE value.
DB2 Session Time: Usually local time Zone. This can be achieved by-
SET SESSION TIMEZONE as -8:00
DB2 Database Time: It is equal to CURRENT TIME ZONE