18. Working with Data Types and Data Display Formats : Data Types : Date Data Type : International Conventions for Date and Time
 
Share this page                  
International Conventions for Date and Time
International date and time conventions can also be adapted. For example, dates in Sweden and Finland are expressed as a year, followed by the month, followed by the day. The standard German date format can be expressed as ddmmyy, ddmmyyy, dd.mm.yy, and dd.mm.yyyy. The date format is set by the system variable II_DATE_FORMAT.
The time zone is set with the system variable, II_TIMEZONE_NAME. These dates are stored in Greenwich mean time. The conversion between Greenwich and your local time is a value set with II_TIMEZONE_NAME. For more information, see the System Administrator Guide for the system on which your database resides.