{"blog_title":"tohokuaiki\u306e\u30c1\u30e9\u30b7\u306e\u88cf","categories":[],"version":"1.0","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftohokuaiki.hateblo.jp%2Fentry%2F2014%2F06%2F30%2F114823\" title=\"MySQL\u3067substring(from_unixtime(created_at), 1, 10)\u3057\u305f\u3089\u30cf\u30de\u3063\u305f\u8a71 - tohokuaiki\u306e\u30c1\u30e9\u30b7\u306e\u88cf\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"tohokuaiki","type":"rich","width":"100%","author_url":"https://blog.hatena.ne.jp/tohokuaiki/","url":"https://tohokuaiki.hateblo.jp/entry/2014/06/30/114823","description":"MySQL5.1\u3067\u3002\u306a\u3093\u304b\u3001\u4ee5\u524d\u306f\u5927\u4e08\u592b\u3060\u3063\u305f\u3093\u3060\u3051\u3069\u2026\u7684\u306a\u3002 SELECT substring( now( ) , 1, 10 ) \u3063\u3066\u3084\u308b\u3068\u3001323031342d30362d3330 \u3068\u304b\u51fa\u308b\u3002\u306a\u3093\u3060\u308d\u3046\uff1f\u3068\u601d\u3063\u3066\u305f\u3089\u578b\u5909\u63db\u3057\u306a\u3044\u3068\u30c0\u30e1\u3063\u307d\u3044\u3002 SELECT cast(substring(now(), 1, 10) as date) \u307f\u305f\u3044\u306b\u3059\u308b\u3068\u30012014-06-30 \u3063\u3066\u8868\u793a\u3055\u308c\u308b\u3002\u30d0\u30a4\u30ca\u30ea\u30fc\u306b\u30ad\u30e3\u30b9\u30c8\u3055\u308c\u3066\u3044\u308b\u3063\u30dd\u30a4\u3002 SELECT cast( \"2014-06-30\" AS BINARY ) \u3067\u3001\u3055\u3063\u304d\u306e\u300c323031342d30362d3330\u300d\u304c\u5f97\u3089\u308c\u308b\u3002 \u8ffd\u8a18 date_fo\u2026","title":"MySQL\u3067substring(from_unixtime(created_at), 1, 10)\u3057\u305f\u3089\u30cf\u30de\u3063\u305f\u8a71","blog_url":"https://tohokuaiki.hateblo.jp/","published":"2014-06-30 11:48:23","height":"190","provider_url":"https://hatena.blog","image_url":null}