November 3rd, 2008
TIME WITH TIME ZONE Data
Posted by
admin in
F. Data Types
The TIME WITH TIME ZONE data type is stored in the ‘HH:MM:SS.MMMMMM -HH:MM’ format. A time column must have a valid time value and can not be blank. The TIME ZONE component shows the offset of the time zone and can range from -12:59 to +13:00. All other SQL rules are the same as they are with TIME.
Example: COL1 TIME WITH TIME ZONE
Sample value is: ’17:39.45 -6:00′
Notice that the keyword, TIME WITH TIME ZONE, is a complete definition of the data type and has no value defined in parentheses. See Sample Data Type Values.
Comments Off
