{"title":"csvsql.cmd \u3067\u8868\u793a\u5f62\u5f0f\u3092\u64cd\u4f5c\u3059\u308b","published":"2013-04-02 13:38:16","blog_url":"https://u87.hatenadiary.org/","url":"https://u87.hatenadiary.org/entry/20130402/1364877496","author_name":"u87","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/u87/","version":"1.0","blog_title":"American Life in the Summertime","description":"http://hp.vector.co.jp/authors/VA033015/csvsql.html csvsql.cmd\u306f\u91cd\u5b9d\u3057\u3066\u307e\u3059\u3002CSV\u306e\u4e2d\u306e\u6642\u523b\u30c7\u30fc\u30bf\u306e\u8868\u793a\u5f62\u5f0f\u304c\u5909\u308f\u3063\u3066\u3057\u307e\u3046\u3002 \u300c10:10\u300d\u3068\u3044\u3046\u30c7\u30fc\u30bf\u304cSELECT\u3059\u308b\u3068\u300cSat Dec 30 10:10:00 UTC+0900 1899\u300d\u3063\u3066\u3002\u3063\u3066\u3053\u3068\u3067\u3001\u8868\u793a\u5f62\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b SELECT format([\u6642\u523b], 'hh:mm') FROM test.csv \u305f\u3060\u3001\u3053\u308c\u3060\u3068\u30ab\u30e9\u30e0\u540d\u300c\u6642\u523b\u300d\u304c\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3046\u3002 SELECT format([\u6642\u523b], 'hh:mm') AS [\u6642\u523b] FROM test.csv \u3068\u3059\u308b\u2026","image_url":null,"height":"190","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fu87.hatenadiary.org%2Fentry%2F20130402%2F1364877496\" title=\"csvsql.cmd \u3067\u8868\u793a\u5f62\u5f0f\u3092\u64cd\u4f5c\u3059\u308b - American Life in the Summertime\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","categories":[],"type":"rich"}