{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,29]],"date-time":"2025-10-29T11:40:03Z","timestamp":1761738003271,"version":"build-2065373602"},"reference-count":41,"publisher":"MDPI AG","issue":"11","license":[{"start":{"date-parts":[[2025,10,24]],"date-time":"2025-10-24T00:00:00Z","timestamp":1761264000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Computers"],"abstract":"<jats:p>Inconsistencies in Earth\u2019s spinning, changes in calendar systems, etc., necessitate time being represented correspondingly. Date\u2013time handling in programming involves specific challenges, including conflicts between calendars, time zone discrepancies, daylight savings, and leap second adjustments\u2014issues that other data types like numbers and text do not encounter. This article identifies these challenges and investigates existing approaches to date\u2013time representation. Limitations in current systems, including how leap seconds, time zone variations, and inconsistent calendar representations complicate date\u2013time handling, is examined. Inconsistent date\u2013time representations imply significant challenges, especially when considering the interplay of leap seconds and time zone shifts. This study highlights the need for a new approach to date\u2013time data types addressing these problems effectively. The article reviews existing date\u2013time data types and explores their shortcomings, proposing a theoretical framework for a more robust solution. The study suggests that an improved date\u2013time data type could enhance time resolution, support leap seconds, and offer greater flexibility in handling time zone shifts. Such a solution would provide a more reliable alternative to current systems. By addressing issues like leap second handling and time zone shifts, the proposed framework demonstrates the feasibility of a new date\u2013time data type, with potential for broader adoption in future systems.<\/jats:p>","DOI":"10.3390\/computers14110461","type":"journal-article","created":{"date-parts":[[2025,10,29]],"date-time":"2025-10-29T04:26:29Z","timestamp":1761711989000},"page":"461","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Approaching Challenges in Representations of Date\u2013Time Ambiguities"],"prefix":"10.3390","volume":"14","author":[{"ORCID":"https:\/\/orcid.org\/0009-0009-7442-183X","authenticated-orcid":false,"given":"Amer","family":"Harb","sequence":"first","affiliation":[{"name":"Department of Computer Science, Faculty of Natural Sciences, Kristianstad University, 291 39 Kristianstad, Sweden"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-5779-381X","authenticated-orcid":false,"given":"Kamilla","family":"Klonowska","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Faculty of Natural Sciences, Kristianstad University, 291 39 Kristianstad, Sweden"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-6519-5051","authenticated-orcid":false,"given":"Daniel","family":"Einarson","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Faculty of Natural Sciences, Kristianstad University, 291 39 Kristianstad, Sweden"}]}],"member":"1968","published-online":{"date-parts":[[2025,10,24]]},"reference":[{"key":"ref_1","unstructured":"The Economic Times (2025, July 22). Earth Is Spinning Faster and Scientists Fear a Y2K\u2014Like Doomsday. Available online: https:\/\/economictimes.indiatimes.com\/news\/international\/global-trends\/earth-is-spinning-faster-and-scientists-fear-a-y2k-like-doomsday\/articleshow\/122841641.cms."},{"key":"ref_2","unstructured":"Dewan, P. (2025, July 24). Earth Is Starting to Spin Faster\u2014And Scientists Are Considering Doing Something Unprecedented. Available online: https:\/\/www.livescience.com\/planet-earth\/earth-is-starting-to-spin-faster-and-scientists-are-considering-doing-something-unprecedented."},{"key":"ref_3","unstructured":"The XML Schema Working Group (2025, October 18). ISO 8601. Available online: https:\/\/www.w3.org\/TR\/xmlschema-2\/."},{"key":"ref_4","unstructured":"(2025, October 18). ISO 8601. Wikipedia, Available online: https:\/\/en.wikipedia.org\/wiki\/ISO_8601."},{"key":"ref_5","doi-asserted-by":"crossref","unstructured":"Mills, D.L. (1994). Unix Kernel Modifications for Precision Time Synchronization. Electrical Engineering Department Report 94-10-1, University of Delaware.","DOI":"10.17487\/rfc1589"},{"key":"ref_6","unstructured":"Crawford, D. (2025, October 18). Forum: The Date Crisis. Available online: https:\/\/cacm.acm.org\/issue\/may-1997\/."},{"key":"ref_7","unstructured":"Microsoft Ignite (2025, October 18). Date Data Type. Available online: https:\/\/learn.microsoft.com\/en-us\/dotnet\/visual-basic\/language-reference\/data-types\/date-data-type."},{"key":"ref_8","unstructured":"(2019). Date and Time Format (Standard No. ISO 8601:2019). Available online: https:\/\/www.iso.org\/iso-8601-date-and-time-format.html."},{"key":"ref_9","unstructured":"Olson, A.D. (2009, May 17). Time Zone and Daylight Saving Time Data. Available online: https:\/\/data.iana.org\/time-zones\/tz-link.html."},{"key":"ref_10","unstructured":"Kuhn, M.G. (2025, October 18). UTC with Smoothed Leap Seconds UTC-SLS. University of Cambridge, Cambridge, UK, Available online: https:\/\/www.cl.cam.ac.uk\/~mgk25\/time\/utc-sls\/."},{"key":"ref_11","unstructured":"Malone, D. (2025, October 18). The Leap Second Behaviour of NTP Servers. In Traffic Monitoring and Analysis Workshop (TMA 2016). Available online: https:\/\/tma.ifip.org\/2016\/papers\/tma2016-final27.pdf."},{"key":"ref_12","unstructured":"Dickerson, K. (2025, October 18). Adding a leap second to the clock this year may cause computer problems. Washington Post, Available online: https:\/\/www.washingtonpost.com\/national\/health-science\/adding-a-leap-second-to-the-clock-this-year-may-cause-computer-problems\/2015\/01\/12\/5ca17474-980e-11e4-8005-1924ede3e54a_story.html."},{"key":"ref_13","doi-asserted-by":"crossref","first-page":"509","DOI":"10.1088\/0026-1394\/38\/6\/6","article-title":"The Leap Second: Its History and Possible Future","volume":"38","author":"Nelson","year":"2003","journal-title":"Metrologia"},{"key":"ref_14","unstructured":"Obleukhov, O., and Byagowi, A. (2025, October 18). It\u2019s time to leave the leap second in the past. Engineering at Meta. Available online: https:\/\/engineering.fb.com\/2022\/07\/25\/production-engineering\/its-time-to-leave-the-leap-second-in-the-past\/."},{"key":"ref_15","doi-asserted-by":"crossref","first-page":"238","DOI":"10.1017\/S0373463300024139","article-title":"The Leap-Second of 31 December 1972","volume":"26","author":"Sadler","year":"1973","journal-title":"J. Navig."},{"key":"ref_16","unstructured":"Oracle (2025, October 18). Class LocalDateTime. Available online: https:\/\/docs.oracle.com\/javase\/8\/docs\/api\/java\/time\/LocalDateTime.html."},{"key":"ref_17","unstructured":"Oracle (2025, October 18). Class Date. Available online: https:\/\/docs.oracle.com\/javase\/8\/docs\/api\/java\/util\/Date.html."},{"key":"ref_18","unstructured":"Oracle (2025, October 18). Class Calendar. Available online: https:\/\/docs.oracle.com\/javase\/8\/docs\/api\/java\/util\/Calendar.html."},{"key":"ref_19","unstructured":"PostgreSQL (2025, October 18). Date\/Time Functions and Operators. Available online: https:\/\/www.postgresql.org\/docs\/current\/functions-datetime.html."},{"key":"ref_20","unstructured":"Wikimedia, C., and Leapsecond (2025, October 18). ut1-utc.svg. Available online: https:\/\/commons.wikimedia.org\/wiki\/File:Leapsecond.ut1-utc.svg."},{"key":"ref_21","unstructured":"GoogleSheet (2025, October 18). Day by Day Differences Between UT1 and UTC Since 1973. Available online: https:\/\/maia.usno.navy.mil\/ser7\/finals.all https:\/\/docs.google.com\/spreadsheets\/d\/1lb332rv49Hqmuy-dsIyAZ4bk0aSqjpT-0h_C1DSdxp8\/edit?usp=sharing."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"144","DOI":"10.1038\/scientificamerican0582-144","article-title":"The Gregorian Calendar","volume":"246","author":"Moyer","year":"1982","journal-title":"Sci. Am."},{"key":"ref_23","unstructured":"Bikos, K., and Kher, A. (2025, October 18). Gregorian Calendar Reform: Why Are Some Dates Missing?. Available online: https:\/\/www.timeanddate.com\/calendar\/julian-gregorian-switch.html."},{"key":"ref_24","unstructured":"Britannica, E. (2025, October 18). Ten Days That Vanished: The Switch to the Gregorian Calendar. Available online: https:\/\/www.britannica.com\/story\/ten-days-that-vanished-the-switch-to-the-gregorian-calendar."},{"key":"ref_25","unstructured":"Shepherd, R. (2025, March 20). The Problem with Dates. Museum Documentation Manager and Art Historian, Available online: https:\/\/rupertshepherd.info\/tag\/proleptic-gregorian-calendar."},{"key":"ref_26","unstructured":"Internet (2025, October 18). Day 875: Why History Is Missing 10 Days (Plus the Weird Story of February 30). Available online: https:\/\/1000words1000days.ca\/2019\/08\/25\/day-875-why-history-is-missing-10-days-plus-the-weird-story."},{"key":"ref_27","unstructured":"Oracle (2025, October 18). Class LocalDate. Available online: https:\/\/docs.oracle.com\/javase\/8\/docs\/api\/java\/time\/LocalDate.html."},{"key":"ref_28","unstructured":"Markham, C.R. (2010). The Journal of Christopher Columbus (During His First Voyage, 1492\u20131493): And Documents Relating the Voyages of John Cabot and Gaspar Corte Real (Cambridge Library Collection\u2014Hakluyt First Series), Cambridge University Press. [Reprint ed.]."},{"key":"ref_29","doi-asserted-by":"crossref","first-page":"769","DOI":"10.1002\/andp.19163540702","article-title":"The Foundation of the General Theory of Relativity","volume":"49","author":"Einstein","year":"1916","journal-title":"Ann. Der Phys."},{"key":"ref_30","unstructured":"DBA (2025, October 18). Leap Second in Database System (Postgresql and SQL Server). Available online: https:\/\/dba.stackexchange.com\/questions\/105514\/leap-second-in-database-system-postgresql-and-sql-server."},{"key":"ref_31","unstructured":"elvanco.com (2025, March 20). How to Handle Leap Seconds in Oracle?. Available online: https:\/\/elvanco.com\/blog\/how-to-handle-leap-seconds-in-oracle."},{"key":"ref_32","unstructured":"Kuhn, M.G. (2025, October 18). Proposal for a Smoothed Coordinated Universal Time (UTS). Cambridge University. Available online: https:\/\/www.ucolick.org\/~sla\/navyls\/0015.html."},{"key":"ref_33","unstructured":"Kuhn, M.G. (2003). Leap-Second Considerations in Distributed Computer Systems. ITU-R SRG 7A Colloquium on the UTC Timescale, International Telecommunication Union."},{"key":"ref_34","unstructured":"Kuhn, M.G. (2025, October 18). Modernized <time.h> for ISO C. Available online: https:\/\/www.cl.cam.ac.uk\/~mgk25\/time\/c\/."},{"key":"ref_35","unstructured":"Mills, D.L. (2025, October 18). The NTP Timescale and Leap Seconds. Available online: https:\/\/www.eecis.udel.edu\/~mills\/leap.html."},{"key":"ref_36","unstructured":"Dimitrov, V. (2018, January 10\u201314). Problems of Date and Time Data Types in Relational Model of Data. Proceedings of the VIII International Conference Distributed Computing and Grid-Technologies in Science and Education, (GRID 2018), Moscow, Russia."},{"key":"ref_37","unstructured":"Codd, E.F. (1990). Relational Model for Database Management: Version 2, Addison-Wesley Longman Publishing Co., Inc."},{"key":"ref_38","unstructured":"Eggert, P. (2025, March 20). FW: IANA Time Zone Registration\u2014Proposal. Available online: https:\/\/mm.icann.org\/pipermail\/tz\/2005-January\/012806.html."},{"key":"ref_39","unstructured":"Hingston, D.R. (2025, March 20). [tz] ICANN News Alert\u2014ICANN to Manage Time Zone Database. Available online: https:\/\/mm.icann.org\/pipermail\/tz\/2011-October\/008090.html."},{"key":"ref_40","unstructured":"Olson, A.D. (2025, March 20). Resolved Timezone Issue? Other Issues. New Ctime Manual Page. tz Mailing List. Available online: https:\/\/mm.icann.org\/pipermail\/tz\/1986-December\/008966.html."},{"key":"ref_41","unstructured":"Harb, A., and Iljaz, W. (2023). Problems and Vision for Date-Time Data Type. [Bachelor\u2019s Thesis, Kristianstad University]. Available online: https:\/\/researchportal.hkr.se\/en\/studentTheses\/problems-and-vision-for-date-time-data-type."}],"container-title":["Computers"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2073-431X\/14\/11\/461\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,29]],"date-time":"2025-10-29T04:53:34Z","timestamp":1761713614000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2073-431X\/14\/11\/461"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,10,24]]},"references-count":41,"journal-issue":{"issue":"11","published-online":{"date-parts":[[2025,11]]}},"alternative-id":["computers14110461"],"URL":"https:\/\/doi.org\/10.3390\/computers14110461","relation":{},"ISSN":["2073-431X"],"issn-type":[{"value":"2073-431X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,10,24]]}}}