{"author_url":"https://blog.hatena.ne.jp/seiunsky/","author_name":"seiunsky","provider_name":"Hatena Blog","image_url":null,"categories":["\u30d7\u30ed\u30b0\u30e9\u30e0","Java","DB"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsugamasao.hatenablog.com%2Fentry%2F20060719%2F1153330191\" title=\"Date\u578b\u3068PreparedStatement\u89e3 - \u3059\u304c\u30d6\u30ed\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"Date\u578b\u3068PreparedStatement\u89e3","height":"190","blog_url":"https://sugamasao.hatenablog.com/","published":"2006-07-19 02:29:51","url":"https://sugamasao.hatenablog.com/entry/20060719/1153330191","description":"\u7d50\u5c40\u3001\u8ffd\u8a18\u306e\u9805\u76ee\u3067\u66f8\u3044\u305f\u611f\u3058\u306e\u3084\u308a\u65b9\u3067Date\u578b\u3067\u53d7\u3051\u6e21\u305b\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u306e\u3060\u304c\u3001\u52d5\u7684\u306b1\u65e5\u524d\u3068\u304b\u306e\u8a08\u7b97\u3092\u3059\u308b\u306e\u304c\u3068\u3066\u3082\u9762\u5012\u3002\u3093\u3067\u2026\u2026\u7d50\u5c40SQL\u6587\u3092TO_DATE\u95a2\u6570\u3067\u30e9\u30c3\u30d4\u30f3\u30b0\u3059\u308b\u3053\u3068\u306b\u3057\u305forz \u3061\u306a\u307f\u306b\u3001\u30cf\u30de\u3063\u3066\u3044\u305f\u6700\u5927\u306e\u539f\u56e0\u306fSELECT\u53e5\u3067\u306eDATE\u578b\u3092\u8868\u793a\u3059\u308b\u969b\u306bNVL\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u5024\u304c\u7121\u304b\u3063\u305f\u5834\u5408\u306f\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3078\u3068\u5909\u63db\u3057\u3066\u3044\u308b\u3068\u3053\u308d\u3060\u3063\u305f*1\u3002 \u3064\u307e\u308a\u3001\u5148\u65e5\u306e\u6642\u70b9\u3067\u306f SQL\u306e\u69cb\u6587\u30a8\u30e9\u30fc \u2192 \u5b9f\u884c\u6642\u306bSQL\u30a8\u30e9\u30fc \u69cb\u6587\u306f\u6210\u529f\uff08\u305f\u3060\u3057\u3001\u691c\u7d22\u5185\u5bb9\u306b\u3088\u3063\u3066SELECT\u53e5\u306eNVL\u95a2\u6570\u3067\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3078\u306e\u5909\u63db\u304c\u304a\u3053\u308b\uff09 \u2192 ORACLE\u30a8\u30e9\u30fc \u3068\u306a\u3063\u3066\u3044\u3066\u3001\u3069\u3063\u3061\u306b\u8ee2\u3093\u3067\u3082\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3088\u3046\u306b\u2026","type":"rich","width":"100%","blog_title":"\u3059\u304c\u30d6\u30ed","provider_url":"https://hatena.blog","version":"1.0"}