%20--%3E%3Cmetadata%20xmlns%3Ardf%3D%22http%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%22%20xmlns%3Axsi%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%22%20xmlns%3Adc%3D%22http%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%22%20xmlns%3Adcterms%3D%22http%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%22%3E%3Crdf%3ARDF%3E%3Crdf%3ADescription%3E%3Cdc%3Atitle%3EShadows%3C%2Fdc%3Atitle%3E%3Cdc%3Acreator%3EDiceBear%3C%2Fdc%3Acreator%3E%3Cdc%3Asource%20xsi%3Atype%3D%22dcterms%3AURI%22%3Ehttps%3A%2F%2Fwww.dicebear.com%3C%2Fdc%3Asource%3E%3Cdcterms%3Alicense%20xsi%3Atype%3D%22dcterms%3AURI%22%3Ehttps%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F%3C%2Fdcterms%3Alicense%3E%3Cdc%3Arights%3E%E2%80%9CShadows%E2%80%9D%20(https%3A%2F%2Fwww.dicebear.com)%20by%20%E2%80%9CDiceBear%E2%80%9D%2C%20licensed%20under%20%E2%80%9CCC0%201.0%E2%80%9D%20(https%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F)%3C%2Fdc%3Arights%3E%3C%2Frdf%3ADescription%3E%3C%2Frdf%3ARDF%3E%3C%2Fmetadata%3E%3Cdefs%3E%3Cg%20id%3D%22shoulders-regular-ecab22d7%22%3E%3Cpath%20d%3D%22M6%2050C6%2017%2020.85%201%2039%201s33%2016%2033%2049Z%22%20fill%3D%22%237b373f%22%2F%3E%3C%2Fg%3E%3Cg%20id%3D%22tops-waves-ecab22d7%22%3E%3Cg%3E%3Ccircle%20cx%3D%2214.5%22%20cy%3D%2223.5%22%20r%3D%227%22%20fill%3D%22%237b373f%22%2F%3E%3Ccircle%20cx%3D%2227%22%20cy%3D%2219%22%20r%3D%227.5%22%20fill%3D%22%237b373f%22%2F%3E%3Ccircle%20cx%3D%2239%22%20cy%3D%2222.5%22%20r%3D%228%22%20fill%3D%22%237b373f%22%2F%3E%3C%2Fg%3E%3C%2Fg%3E%3Cg%20id%3D%22heads-wide-ecab22d7%22%3E%3Cuse%20transform%3D%22translate(.05%202.32)scale(1.11)%20rotate(-6%2C%2028%2C%2025)%22%20href%3D%22%23tops-waves-ecab22d7%22%2F%3E%3Cellipse%20cx%3D%2231%22%20cy%3D%2238%22%20rx%3D%2221%22%20ry%3D%2218%22%20fill%3D%22%237b373f%22%2F%3E%3C%2Fg%3E%3CclipPath%20id%3D%22clip-ecab22d7%22%3E%3Crect%20width%3D%22100%22%20height%3D%22100%22%20rx%3D%220%22%20ry%3D%220%22%2F%3E%3C%2FclipPath%3E%3C%2Fdefs%3E%3Cg%20clip-path%3D%22url(%23clip-ecab22d7)%22%3E%3Crect%20width%3D%22100%22%20height%3D%22100%22%20fill%3D%22%23dfe8ed%22%2F%3E%3Cuse%20transform%3D%22translate(11%2051)%22%20href%3D%22%23shoulders-regular-ecab22d7%22%2F%3E%3Cuse%20transform%3D%22translate(19%201)%22%20href%3D%22%23heads-wide-ecab22d7%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E)
🔗 Storing times for human events #best-practice #database #postgresql #reading-list #sql
simonwillison.netStoring times for human events#best-practice #database #postgresql #reading-list #sql
Post
%20--%3E%3Cmetadata%20xmlns%3Ardf%3D%22http%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%22%20xmlns%3Axsi%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%22%20xmlns%3Adc%3D%22http%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%22%20xmlns%3Adcterms%3D%22http%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%22%3E%3Crdf%3ARDF%3E%3Crdf%3ADescription%3E%3Cdc%3Atitle%3EShadows%3C%2Fdc%3Atitle%3E%3Cdc%3Acreator%3EDiceBear%3C%2Fdc%3Acreator%3E%3Cdc%3Asource%20xsi%3Atype%3D%22dcterms%3AURI%22%3Ehttps%3A%2F%2Fwww.dicebear.com%3C%2Fdc%3Asource%3E%3Cdcterms%3Alicense%20xsi%3Atype%3D%22dcterms%3AURI%22%3Ehttps%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F%3C%2Fdcterms%3Alicense%3E%3Cdc%3Arights%3E%E2%80%9CShadows%E2%80%9D%20(https%3A%2F%2Fwww.dicebear.com)%20by%20%E2%80%9CDiceBear%E2%80%9D%2C%20licensed%20under%20%E2%80%9CCC0%201.0%E2%80%9D%20(https%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F)%3C%2Fdc%3Arights%3E%3C%2Frdf%3ADescription%3E%3C%2Frdf%3ARDF%3E%3C%2Fmetadata%3E%3Cdefs%3E%3Cg%20id%3D%22shoulders-narrow-b50ad14d%22%3E%3Cpath%20d%3D%22M11%2050C11%2018%2023.6%200%2039%200s28%2018%2028%2050Z%22%20fill%3D%22%233b3b42%22%2F%3E%3C%2Fg%3E%3Cg%20id%3D%22tops-flat-b50ad14d%22%3E%3Cpath%20d%3D%22M12.5%2036V14q0-4%204-4h23q4%200%204%204v22q-15.5%207-31%200%22%20fill%3D%22%233b3b42%22%2F%3E%3C%2Fg%3E%3Cg%20id%3D%22heads-round-b50ad14d%22%3E%3Cuse%20transform%3D%22translate(3%203)%20rotate(-3%2C%2028%2C%2025)%22%20href%3D%22%23tops-flat-b50ad14d%22%2F%3E%3Ccircle%20cx%3D%2231%22%20cy%3D%2238%22%20r%3D%2219%22%20fill%3D%22%233b3b42%22%2F%3E%3C%2Fg%3E%3CclipPath%20id%3D%22clip-b50ad14d%22%3E%3Crect%20width%3D%22100%22%20height%3D%22100%22%20rx%3D%220%22%20ry%3D%220%22%2F%3E%3C%2FclipPath%3E%3C%2Fdefs%3E%3Cg%20clip-path%3D%22url(%23clip-b50ad14d)%22%3E%3Crect%20width%3D%22100%22%20height%3D%22100%22%20fill%3D%22%23ede4e4%22%2F%3E%3Cuse%20transform%3D%22translate(11%2051)%22%20href%3D%22%23shoulders-narrow-b50ad14d%22%2F%3E%3Cuse%20transform%3D%22translate(19%201)%22%20href%3D%22%23heads-round-b50ad14d%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E)
For #ElixirLang folks this article is the same idea: hexdocs.pm/date_time_pa...
hexdocs.pmFuture DateTime UTC timestamps — DateTimeParser v1.2.0
3 reposts10 likes
%20--%3E%3Cmetadata%20xmlns%3Ardf%3D%22http%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%22%20xmlns%3Axsi%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%22%20xmlns%3Adc%3D%22http%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%22%20xmlns%3Adcterms%3D%22http%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%22%3E%3Crdf%3ARDF%3E%3Crdf%3ADescription%3E%3Cdc%3Atitle%3EShadows%3C%2Fdc%3Atitle%3E%3Cdc%3Acreator%3EDiceBear%3C%2Fdc%3Acreator%3E%3Cdc%3Asource%20xsi%3Atype%3D%22dcterms%3AURI%22%3Ehttps%3A%2F%2Fwww.dicebear.com%3C%2Fdc%3Asource%3E%3Cdcterms%3Alicense%20xsi%3Atype%3D%22dcterms%3AURI%22%3Ehttps%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F%3C%2Fdcterms%3Alicense%3E%3Cdc%3Arights%3E%E2%80%9CShadows%E2%80%9D%20(https%3A%2F%2Fwww.dicebear.com)%20by%20%E2%80%9CDiceBear%E2%80%9D%2C%20licensed%20under%20%E2%80%9CCC0%201.0%E2%80%9D%20(https%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F)%3C%2Fdc%3Arights%3E%3C%2Frdf%3ADescription%3E%3C%2Frdf%3ARDF%3E%3C%2Fmetadata%3E%3Cdefs%3E%3Cg%20id%3D%22shoulders-square-e6b28f35%22%3E%3Cpath%20d%3D%22M4%2050V17C4%209%2010%203%2018%203h42c8%200%2014%206%2014%2014v33Z%22%20fill%3D%22%235e3b87%22%2F%3E%3C%2Fg%3E%3Cg%20id%3D%22tops-curls-e6b28f35%22%3E%3Cg%3E%3Ccircle%20cx%3D%2210.52%22%20cy%3D%2225.5%22%20r%3D%227%22%20fill%3D%22%235e3b87%22%2F%3E%3Ccircle%20cx%3D%2218.5%22%20cy%3D%2216.95%22%20r%3D%227.5%22%20fill%3D%22%235e3b87%22%2F%3E%3Ccircle%20cx%3D%2228.95%22%20cy%3D%2215.05%22%20r%3D%227.5%22%20fill%3D%22%235e3b87%22%2F%3E%3Ccircle%20cx%3D%2239.4%22%20cy%3D%2217.9%22%20r%3D%227.5%22%20fill%3D%22%235e3b87%22%2F%3E%3Ccircle%20cx%3D%2246.05%22%20cy%3D%2226.45%22%20r%3D%227%22%20fill%3D%22%235e3b87%22%2F%3E%3C%2Fg%3E%3C%2Fg%3E%3Cg%20id%3D%22heads-oval-e6b28f35%22%3E%3Cuse%20transform%3D%22matrix(.95%200%200%20.95%204.47%201.84)%20rotate(-6%2C%2028%2C%2025)%22%20href%3D%22%23tops-curls-e6b28f35%22%2F%3E%3Cellipse%20cx%3D%2231%22%20cy%3D%2238%22%20rx%3D%2218%22%20ry%3D%2221%22%20fill%3D%22%235e3b87%22%2F%3E%3C%2Fg%3E%3CclipPath%20id%3D%22clip-e6b28f35%22%3E%3Crect%20width%3D%22100%22%20height%3D%22100%22%20rx%3D%220%22%20ry%3D%220%22%2F%3E%3C%2FclipPath%3E%3C%2Fdefs%3E%3Cg%20clip-path%3D%22url(%23clip-e6b28f35)%22%3E%3Crect%20width%3D%22100%22%20height%3D%22100%22%20fill%3D%22%23ede4e4%22%2F%3E%3Cuse%20transform%3D%22translate(11%2051)%22%20href%3D%22%23shoulders-square-e6b28f35%22%2F%3E%3Cuse%20transform%3D%22translate(19%201)%22%20href%3D%22%23heads-oval-e6b28f35%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E)
There‘s also hexdocs.pm/tz_datetime/... which implements a few helpers on that
hexdocs.pmTzDatetime — tz_datetime v0.1.3