{"image_url":null,"categories":["DB2","SQL Server"],"published":"2007-05-28 17:55:12","type":"rich","author_name":"htada","blog_url":"https://htada.hatenadiary.org/","title":"\u65e5\u4ed8\u306e\u8db3\u3057\u5f15\u304d","author_url":"https://blog.hatena.ne.jp/htada/","description":"\u666e\u6bb5\u3001SQL Server 2000\u3092\u4e3b\u306b\u4f7f\u3063\u3066\u3044\u308b\u306e\u3067\u3001DB2\u3067\u3082dateadd\u307f\u305f\u3044\u306a\u95a2\u6570\u3067\u3084\u308b\u306e\u304b\u306a\u3041\u3068SQL\u672c\u3067\u8abf\u3079\u3066\u3044\u305f\u3089\u3002 \u300c\u305d\u308c\u3001\u8db3\u3059\uff11\u30c7\u30a4\u3067\u3067\u304d\u307e\u3059\u3088\u300d\u3068\u540c\u50da\u304b\u3089\u306e\u304a\u8a00\u8449\u3002 DB2\u3067 \u307b\u3093\u3068\u304b\u305d\u308c\u3068\u601d\u3063\u3066\u3084\u3063\u3066\u307f\u305f\u3089\u3001\u51fa\u6765\u305f\u3002 select current timestamp as current, current timestamp + 1 year as \u5e74, current timestamp + 1 month as \u6708, current timestamp + 1 day as \u65e5, current timestamp + 1 hour as \u6642, current t\u2026","version":"1.0","width":"100%","url":"https://htada.hatenadiary.org/entry/20070528/1180342512","blog_title":"\u305f\u3060\u3076\u308d\u3050","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtada.hatenadiary.org%2Fentry%2F20070528%2F1180342512\" title=\"\u65e5\u4ed8\u306e\u8db3\u3057\u5f15\u304d - \u305f\u3060\u3076\u308d\u3050\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","provider_name":"Hatena Blog"}