
So for example it patched 12:25 when it should have done 14:25. So the problem is that it patches local times, instead of UTC. The problem is, that it gets patched to the DB (where the "now" variable is basically Now() that refreshes often).
8 UTC TIME PATCH
So when the work trip starts, I patch it to our database like so: As per this article: I'm trying to convert whatever the user is entering to UTC and then display it back. After 1975, the whole country came under the North Vietnamese time zone, UTC+07:00.Īccording to Presidential Decree 41/1987, Indonesia's ex-province of Timor Timur used this time zone with neighboring East Nusa Tenggara and other provinces in Lesser Sunda Islands, parts of Kalimantan and Sulawesi until independence as East Timor, which the country changed to UTC+09:00 as official time zone.I'm building an application for work travel, that is writing to a database that has the UTC timezone set, and then writes things to our ERP which is also set to UTC timezone. The southern half of Vietnam ( Republic of Vietnam) was formerly part of this time zone prior to the national reunification on 30 April 1975, making it one hour ahead of North Vietnam.
Parts of western China including western Xinjiang province ( Kashgar) (although most locals observe UTC+06:00 even if it is officially UTC+08:00). See also Time in China.Īreas between 67☃0′ E and 82☃0′ E ("physical" UTC+05:00) most of Xinjiang Uyghur Autonomous Region (although many locals set their clocks at UTC+06:00 even if it is officially UTC+08:00, in any case work and shop schedules are two hours after Shanghai and Beijing). Most of central Mongolia including the capital Ulaanbaatar.Īreas between 82☃0′ E and 97☃0′ E ("physical" UTC+06:00). Inner Mongolia, including its capital Hohhot. Peninsular Malaysia, where the nation's capital Kuala Lumpur is located. Eastern part of Malaysia on Borneo, the state of Sabah and Sarawak. Easternmost parts of Western Australia.Īreas between 97☃0′ E and 112☃0′ E ("physical" UTC+07:00). Parts of northeast China including the eastern half of Heilongjiang Province and the Yanbian Korean Autonomous Prefecture in Jilin Province. The western parts of Korea, including the North Korean capital city, Pyongyang and South Korean capital city, Seoul, where UTC+09:00 is used.Īreas located outside UTC+08:00 longitudes using UTC+08:00 time Areas between 127☃0′ E and 142☃0′ E ("physical" UTC+09:00). Parts of Okinawa Prefecture, Japan, including Sakishima Islands with its westernmost point Yonaguni, western parts of Kerama Islands, and some islands of the western Okinawa Islands, where UTC+09:00 is used. Parts of Indonesia, including eastern East Java with its capital city Surabaya, most of Central Kalimantan with its capital city Palangka Raya, and eastern part of West Kalimantan, where UTC+07:00 is used, and some of the western islands in the province of Maluku and North Maluku where UTC+09:00 is used. Parts of Russia, including very easternmost parts of Krasnoyarsk Krai, where UTC+07:00 is used, and Zabaykalsky Krai and most of western Sakha Republic where UTC+09:00 is used. This concerns areas within 112☃0′ E to 127☃0′ E longitude. This section is only partly updated for longitudes using other time zones. See also Time in Antarcticaĭiscrepancies between official UTC+08:00 and geographical UTC+08:00 Western Australia (except Eucla and nearby areas, including Caiguna, Cocklebiddy, Madura and Mundrabilla, unofficially observes UTC+08:45 )Īntarctica Southern Ocean. Brunei – Brunei Darussalam Standard Time. Eastern part, including Dornod, Sükhbaatar, Ulaanbaatar.
Macau – Macau Time (Macau Standard Time).Hong Kong – Hong Kong Time (Hong Kong Standard Time).Principal cities: Shanghai, Beijing, Taipei, Hong Kong, Kuala Lumpur, Singapore, Manila, Makassar, Denpasar, Perth, Irkutsk North Asia 2.1 Areas located outside UTC+08:00 longitudes using UTC+08:00 time.2 Discrepancies between official UTC+08:00 and geographical UTC+08:00.