Date, Time, and Timezones in Business Apps — From DateTime Pitfalls to the UTC-Storage Principle and Test Design (archived 2026-07-27)

Timestamps drift by nine hours after a server migration; only the overseas office's dates roll back to the previous day — we trace date/time incidents back to DateTime's Kind property and its implicit conversions. This article covers when to use DateTimeOffset instead, the principle of storing UTC and ISO 8601, TimeZoneInfo and daylight saving time, the boundary with SQL Server/SQLite, and test design with TimeProvider, all from a hands-on engineering perspective. Archived version of https://comcomponent.com/en/blog/business-app-datetime-timezone-guide/, as published on 2026-07-27. The live article is maintained and may change after this date. First published 2026-07-03.

Authors

Institutions

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-07-27
DOI
https://doi.org/10.5281/zenodo.21614723
Primary Topic
Personal Information Management and User Behavior
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Date, Time, and Timezones in Business Apps — From DateTime Pitfalls to the UTC-Storage Principle and Test Design (archived 2026-07-27)

Go Komura
Zenodo (CERN European Organization for Nuclear Research)
Personal Information Management and User Behavior
article

Date, Time, and Timezones in Business Apps — From DateTime Pitfalls to the UTC-Storage Principle and Test Design (archived 2026-07-27)

Go Komura
article en

Abstract

Timestamps drift by nine hours after a server migration; only the overseas office's dates roll back to the previous day — we trace date/time incidents back to DateTime's Kind property and its implicit conversions. This article covers when to use DateTimeOffset instead, the principle of storing UTC and ISO 8601, TimeZoneInfo and daylight saving time, the boundary with SQL Server/SQLite, and test design with TimeProvider, all from a hands-on engineering perspective. Archived version of https://comcomponent.com/en/blog/business-app-datetime-timezone-guide/, as published on 2026-07-27. The live article is maintained and may change after this date. First published 2026-07-03.

Zenodo (CERN European Organization for Nuclear Research)
Fujikura (United States) (US)
Reduced inequalities
Openalex Percentile: Top 4%
Personal Information Management and User Behavior
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.