{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,10,25]],"date-time":"2023-10-25T05:37:17Z","timestamp":1698212237512},"reference-count":10,"publisher":"Wiley","issue":"1","license":[{"start":{"date-parts":[[2006,10,30]],"date-time":"2006-10-30T00:00:00Z","timestamp":1162166400000},"content-version":"vor","delay-in-days":4685,"URL":"http:\/\/onlinelibrary.wiley.com\/termsAndConditions#vor"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Softw Pract Exp"],"published-print":{"date-parts":[[1994,1]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>In this paper we provide efficient algorithms for converting between timestamp values that signify some number of seconds from an arbitrary origin, and character strings specifying Gregorian dates, such as \u2018January 1, 1993\u2019. We give several algorithms that explore a range of time and space trade\u2010offs. Unlike previous algorithms, those discussed here have a constant time cost over a greatly extended range of timestamp values. These algorithms are especially useful in operating systems and in database management systems.<\/jats:p>","DOI":"10.1002\/spe.4380240106","type":"journal-article","created":{"date-parts":[[2006,11,17]],"date-time":"2006-11-17T16:48:57Z","timestamp":1163782137000},"page":"89-109","source":"Crossref","is-referenced-by-count":2,"title":["Efficient timestamp input and output"],"prefix":"10.1002","volume":"24","author":[{"given":"Curtis E.","family":"Dyreson","sequence":"first","affiliation":[]},{"given":"Richard T.","family":"Snodgrass","sequence":"additional","affiliation":[]}],"member":"311","published-online":{"date-parts":[[2006,10,30]]},"reference":[{"key":"e_1_2_1_2_2","unstructured":"A. U.Tansel \u2018Temporal relational data model\u2019 Technical Report Department of Computer Engineering Bernard M. Baruch College CUNY1992."},{"key":"e_1_2_1_3_2","doi-asserted-by":"publisher","DOI":"10.1002\/spe.4380200905"},{"key":"e_1_2_1_4_2","doi-asserted-by":"publisher","DOI":"10.1002\/spe.4380230404"},{"key":"e_1_2_1_5_2","unstructured":"M.SooandR.Snodgrass \u2018Mixed calendar query language support for temporal constants\u2019 TempIS Technical Report 29 Computer Science Department University of Arizona Revised May1992."},{"key":"e_1_2_1_6_2","unstructured":"M.Soo R.Snodgrass C.Dyreson C. S.JensenandN.Kline \u2018Architectural extensions to support multiple calendars\u2019 TempIS Technical Report 32 Computer Science Department University of Arizona Revised May1992."},{"key":"e_1_2_1_7_2","doi-asserted-by":"publisher","DOI":"10.1016\/0306-4379(93)90034-X"},{"key":"e_1_2_1_8_2","volume-title":"Abstraction and Specification in Program Development","author":"Liskov B.","year":"1986"},{"key":"e_1_2_1_9_2","unstructured":"J. F.Allen \u2018An internal\u2010based representation of temporal knowledge\u2019 Proceedings of the International Joint Conference on Artificial Intelligence Vancouver 1981 pp.221\u2013226."},{"key":"e_1_2_1_10_2","volume-title":"Empires of Time: Calendars, Clocks, and Cultures","author":"Aveni A. F.","year":"1989"},{"key":"e_1_2_1_11_2","volume-title":"Time the Familiar Stranger","author":"Fraser J.","year":"1987"}],"container-title":["Software: Practice and Experience"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.wiley.com\/onlinelibrary\/tdm\/v1\/articles\/10.1002%2Fspe.4380240106","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1002\/spe.4380240106","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,24]],"date-time":"2023-10-24T23:49:42Z","timestamp":1698191382000},"score":1,"resource":{"primary":{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/10.1002\/spe.4380240106"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1994,1]]},"references-count":10,"journal-issue":{"issue":"1","published-print":{"date-parts":[[1994,1]]}},"alternative-id":["10.1002\/spe.4380240106"],"URL":"https:\/\/doi.org\/10.1002\/spe.4380240106","archive":["Portico"],"relation":{},"ISSN":["0038-0644","1097-024X"],"issn-type":[{"value":"0038-0644","type":"print"},{"value":"1097-024X","type":"electronic"}],"subject":[],"published":{"date-parts":[[1994,1]]}}}