{"description":"\u4f8b\uff09\u9000\u793e\u6642\u9593 - \u59cb\u696d\u6642\u9593 = \u52b4\u50cd\u6642\u9593\u3068\u3057\u3001\u305d\u306e\u7dcf\u6642\u9593\u3092\u7b97\u51fa\u3059\u308b SELECT SUM(worktime_end - worktime_start) FROM mst_worktimemst_worktime\uff1a\u52b4\u50cd\u6642\u9593\u30c6\u30fc\u30d6\u30eb worktime_start\uff08TIME\u578b\uff09\uff1a\u59cb\u696d\u6642\u9593 worktime_end\uff08TIME\u578b\uff09\uff1a\u9000\u793e\u6642\u9593 \u4f8b\uff09 system=# select id, created_at, updated_at from table where id in (12,17); id | created_at | updated_at - 12 | 2010-05-31 20:42:42\u2026","published":"2009-01-31 10:48:49","height":"190","version":"1.0","image_url":null,"provider_url":"https://hatena.blog","width":"100%","title":"\u6642\u9593\u306e\u5dee\u3068\u96c6\u8a08","type":"rich","author_url":"https://blog.hatena.ne.jp/moroto1122/","blog_url":"https://moroto1122.hatenadiary.org/","author_name":"moroto1122","provider_name":"Hatena Blog","blog_title":"Web\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u6280\u8853\u30e1\u30e2\u3000\u301cPHP\u3001SQL\u3001Linux\u306a\u3069\u301c","url":"https://moroto1122.hatenadiary.org/entry/20090131/1233366529","categories":["SQL","Postgres"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmoroto1122.hatenadiary.org%2Fentry%2F20090131%2F1233366529\" title=\"\u6642\u9593\u306e\u5dee\u3068\u96c6\u8a08 - Web\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u6280\u8853\u30e1\u30e2\u3000\u301cPHP\u3001SQL\u3001Linux\u306a\u3069\u301c\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}