{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:23:39Z","timestamp":1750307019672,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":12,"publisher":"ACM","license":[{"start":{"date-parts":[[2012,3,29]],"date-time":"2012-03-29T00:00:00Z","timestamp":1332979200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"DOI":"10.13039\/100005714","name":"Office of Experimental Program to Stimulate Competitive Research","doi-asserted-by":"publisher","award":["EPS-0903787"],"award-info":[{"award-number":["EPS-0903787"]}],"id":[{"id":"10.13039\/100005714","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2012,3,29]]},"DOI":"10.1145\/2184512.2184554","type":"proceedings-article","created":{"date-parts":[[2012,4,17]],"date-time":"2012-04-17T12:53:22Z","timestamp":1334667202000},"page":"176-181","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":1,"title":["MySQL and the trouble with temporal data"],"prefix":"10.1145","author":[{"given":"Chad","family":"Vicknair","sequence":"first","affiliation":[{"name":"University of Mississippi, University, MS"}]},{"given":"Dawn","family":"Wilkins","sequence":"additional","affiliation":[{"name":"University of Mississippi, University, MS"}]},{"given":"Yixin","family":"Chen","sequence":"additional","affiliation":[{"name":"University of Mississippi, University, MS"}]}],"member":"320","published-online":{"date-parts":[[2012,3,29]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.5555\/556858"},{"volume-title":"Morgan Kaufmann","year":"2002","author":"Date C. J.","key":"e_1_3_2_1_2_1"},{"key":"e_1_3_2_1_3_1","unstructured":"Digital Equipment Corporation. Database Langauge SQL chapter 4.5 Datetimes and intervals. July 1992.  Digital Equipment Corporation. Database Langauge SQL chapter 4.5 Datetimes and intervals. July 1992."},{"volume-title":"ISO\/IEC","year":"2004","author":"International Organization for Standardization. ISO 8601","key":"e_1_3_2_1_4_1"},{"key":"e_1_3_2_1_5_1","unstructured":"MySQL. MySQL 5.1 Reference Manual chapter 1.8 MySQL Standards Compliance. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/compatibility.html.  MySQL. MySQL 5.1 Reference Manual chapter 1.8 MySQL Standards Compliance. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/compatibility.html."},{"key":"e_1_3_2_1_6_1","unstructured":"MySQL. MySQL 5.1 Reference Manual chapter 10.3.1 The DATE DATETIME and TIMESTAMP Types. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/datetime.html.  MySQL. MySQL 5.1 Reference Manual chapter 10.3.1 The DATE DATETIME and TIMESTAMP Types. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/datetime.html."},{"key":"e_1_3_2_1_7_1","unstructured":"MySQL. MySQL 5.1 Reference Manual chapter 10.3.1.1 TIMESTAMP Properties. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/timestamp.html.  MySQL. MySQL 5.1 Reference Manual chapter 10.3.1.1 TIMESTAMP Properties. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/timestamp.html."},{"key":"e_1_3_2_1_8_1","unstructured":"MySQL. MySQL 5.1 Reference Manual chapter 10.3.2 The TIME Type. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/time.html.  MySQL. MySQL 5.1 Reference Manual chapter 10.3.2 The TIME Type. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/time.html."},{"key":"e_1_3_2_1_9_1","unstructured":"MySQL. MySQL 5.1 Reference Manual chapter 11.7 Date and Time Functions. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/date-and-time-functions.html.  MySQL. MySQL 5.1 Reference Manual chapter 11.7 Date and Time Functions. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/date-and-time-functions.html."},{"key":"e_1_3_2_1_10_1","unstructured":"MySQL. MySQL 5.1 Reference Manual chapter 11.8 What Calendar Is Used By MySQL? 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/mysql-calendar.html.  MySQL. MySQL 5.1 Reference Manual chapter 11.8 What Calendar Is Used By MySQL? 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/mysql-calendar.html."},{"key":"e_1_3_2_1_11_1","unstructured":"MySQL. MySQL 5.5 Reference Manual chapter 10.3.4 Fractional Seconds in Time. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/fractional-seconds.html.  MySQL. MySQL 5.5 Reference Manual chapter 10.3.4 Fractional Seconds in Time. 2009. http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/fractional-seconds.html."},{"key":"e_1_3_2_1_12_1","unstructured":"MySQL. MySQL 5.6 Reference Manual chapter 10.3.1 The DATE DATETIME and TIMESTAMP Types. 2011. http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/datetime.html.  MySQL. MySQL 5.6 Reference Manual chapter 10.3.1 The DATE DATETIME and TIMESTAMP Types. 2011. http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/datetime.html."}],"event":{"name":"ACM SE '12: ACM Southeast Regional Conference","sponsor":["ACM Association for Computing Machinery"],"location":"Tuscaloosa Alabama","acronym":"ACM SE '12"},"container-title":["Proceedings of the 50th Annual Southeast Regional Conference"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2184512.2184554","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2184512.2184554","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T08:49:11Z","timestamp":1750236551000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2184512.2184554"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,3,29]]},"references-count":12,"alternative-id":["10.1145\/2184512.2184554","10.1145\/2184512"],"URL":"https:\/\/doi.org\/10.1145\/2184512.2184554","relation":{},"subject":[],"published":{"date-parts":[[2012,3,29]]},"assertion":[{"value":"2012-03-29","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}