Time Zone¶
Topics
Summary¶
About Time Zone Support¶
Time zone support is a mechanism to properly covert the time zone so that the date and time data can be compared and converted worldwide.This support includes automatic judgment of summer time by the system and the coonversion process of date and time data.In order for the user to access date and time data that matches with his/her time zone, it is necessary that time zone can be set for each user.If the time zone of date and time data for each user is different from each other,it may not be possible to utilize the information effectively.Therefore, date and time data converted by the unified time zone will be stored on the system side.
Time Zone Support in intra-mart Accel Platform¶
There are 5 elements that make up the time zone support of intra-mart Accel Platform.
- Time Zone Definition
Time zone which is used in intra-mart Accel Platform is defined.
- Date and time data are converted by the unified time zone and are stored.
Date and time data are converted by the unified time zone and stored to DB.
- Time Zone Resolution
User can register the time zone to be used to intra-mart Accel Platform.If nothing has been registered, automatically resolved time zone will be applied.For the resolution sequence of time zone, please refer to Defined Access Context.
- Date and time data are converted to user’s time zone.
When the date and time data are displayed on the screen, they should have been converted to user’s time zone.For the conversion to user’s time zone, please refer to Utilize User Time Zone and Date and Time Format.
- Summer Time Support
Time Zone Definition¶
Time Zone Definition at Initial State¶
Please see below for the time zone defined in intra-mart Accel Platform at initial state.
- Time Zone Master File
Time zone defined in intra-mart Accel Platform is stated in the XML named [Time Zonte Master File].System default time zone at initial state is the time zone of JDK.
Setting File
<CONTEXT_PATH>/WEB-INF/conf/time-zone-config/im-time-zone-config.xml
Convert Date and Time data by unified time zone and Save¶
System Requirements¶
In order to process the date and time data for the same time zone on the system side, there are following limitations in the operating environment of intra-mart Accel Platform.
- TIMESTAMP type is used as DB data type that stores date and time data.
datetime or datetime2 is used in SQL Server.Warning
In order to ensure the integrity of date and time data after time zone conversion in intra-mart Accel Platform, TIMESTAMP type is recommended for the DB column that stores date and time data.Since time zone conversion for the TIMESTAMP type with time zone depends on the DB specifications, it is not possible to gurantee the integrity of date and time data on the intra-mart Accel Platform side.Therefore, please do not use TIMESTAMP type with time zone.
- Date and time data are converted and stored by the system default time zone.
System default time zone is the same as the time zone of JDK.
- In the distributed environment, every time zone of Java VM should be made the same.
- You should not change the time zone of Java VM after the system operation started.
Summer Time¶
About Summer Time¶
During summer time certain time period may be added to the current time to best utilize the daylight time. Use of this adjusted time zone system or added time period is called a Summer Time.This system depends on the political situation of the region, and so the implementatio period and the adjusted time period are not fixed. It may not be even certain if it is implemented or not.
Summer Time Support in intra-mart Accel Platform¶
Summer time information provided by Java is utilized by intra-mart Accel Platform, and summer time is automatically applied to the corresponding time zone.