{"height":"190","author_name":"shinkufencer","blog_title":"\u30b3\u30fc\u30c9\u65e5\u9032\u6708\u6b69","url":"https://shinkufencer.hateblo.jp/entry/2019/12/01/000000","width":"100%","blog_url":"https://shinkufencer.hateblo.jp/","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshinkufencer.hateblo.jp%2Fentry%2F2019%2F12%2F01%2F000000\" title=\"MySQL\u306etimestamp\u578b\u306f2038\u5e74\u554f\u984c\u304c\u3042\u308b\u304c\u3001datetime\u578b\u306f9999\u5e74\u307e\u3067\u53ef\u80fd\u3002 - \u30b3\u30fc\u30c9\u65e5\u9032\u6708\u6b69\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"MySQL\u306etimestamp\u578b\u306f2038\u5e74\u554f\u984c\u304c\u3042\u308b\u304c\u3001datetime\u578b\u306f9999\u5e74\u307e\u3067\u53ef\u80fd\u3002","author_url":"https://blog.hatena.ne.jp/shinkufencer/","provider_name":"Hatena Blog","type":"rich","categories":["MySQL"],"published":"2019-12-01 00:00:00","provider_url":"https://hatena.blog","image_url":null,"description":"\u300cMySQL\u3063\u3066\u3069\u308c\u3050\u3089\u3044\u5148\u307e\u3067\u8a2d\u5b9a\u3067\u304d\u308b\u3093\u3060\u3063\u3051\uff1f\u300d\u3068\u3044\u3046\u8b70\u8ad6\u304c\u8d77\u3053\u308b\u306e\u3067\u30e1\u30e2 \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u66f0\u304f DATETIME \u307e\u305f\u306f TIMESTAMP \u5024\u306b\u306f\u3001\u30de\u30a4\u30af\u30ed\u79d2 (6 \u6841) \u307e\u3067\u306e\u7cbe\u5ea6\u3067\u5f8c\u7d9a\u306e\u5c0f\u6570\u79d2\u90e8\u5206\u3092\u542b\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u7279\u306b\u3001MySQL 5.6.4 \u4ee5\u964d\u3067\u306f\u3001DATETIME \u307e\u305f\u306f TIMESTAMP \u30ab\u30e9\u30e0\u306b\u633f\u5165\u3055\u308c\u305f\u5024\u306e\u5c0f\u6570\u90e8\u306f\u3059\u3079\u3066\u7834\u68c4\u3055\u308c\u305a\u306b\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\u5c0f\u6570\u90e8\u304c\u542b\u307e\u308c\u308b\u5834\u5408\u3001\u3053\u308c\u3089\u306e\u5024\u306e\u5f62\u5f0f\u306f 'YYYY-MM-DD HH:MM:SS[.fraction]' \u3067\u3042\u308a\u3001DATETIME \u5024\u306e\u7bc4\u56f2\u306f '1000-01-01 00:00:00.000000' \u304b\u3089 '9999-\u2026"}