{"id":130,"date":"2016-02-26T18:33:47","date_gmt":"2016-02-26T09:33:47","guid":{"rendered":"http:\/\/medicalfields.jp\/blog\/?p=130"},"modified":"2017-03-02T14:01:40","modified_gmt":"2017-03-02T05:01:40","slug":"130","status":"publish","type":"post","link":"https:\/\/medicalfields.jp\/blog\/%e3%83%97%e3%83%ad%e3%82%b0%e3%83%a9%e3%83%9f%e3%83%b3%e3%82%b0\/130\/","title":{"rendered":"\u548c\u66a6\u304b\u3089\u897f\u66a6\u3078"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>\u548c\u66a6\u306e\u3050\u3061\u3083\u3050\u3061\u3083\u306aString\u304b\u3089SQL\u69d8\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u5909\u63db\u3059\u308b\u3084\u3064\u3067\u307e\u3042\u307e\u3042\u306a\u51fa\u6765\u306a\u306e\u304c\u51fa\u6765\u305f\u3002<\/p>\n<p>\u307b\u3093\u3068\u306fstrftime\u3066\u304d\u306a\u306e\u3067\u3084\u308a\u305f\u304b\u3063\u305f\u3051\u3069Windows\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u306a\u3044\u304b\u3089\u81ea\u4f5c<\/p>\n<p>\u6b63\u898f\u8868\u73fe\u306f\u5049\u5927\u3060\u3063\u305f\u3002<\/p>\n<pre class=\"php\">public static function convNumStringtoDate($src) {\r\n    \t$outputArray=<a href=\"http:\/\/www.php.net\/array\">array<\/a>();\r\n    \t\/\/\u662d\u548c\u3068\u304b\u3092\u897f\u66a6\u306b\u3060\u3051\u5909\u63db\u3000\u8907\u6570\u306f\u30a2\u30ec\u30a4\u306b\r\n    \t$src=<a href=\"http:\/\/www.php.net\/mb_convert_kana\">mb_convert_kana<\/a>($src, \"ah\", \"UTF-8\");\/\/\t\u300c\u5168\u89d2\u300d\u82f1\u6570\u5b57\u3092\u300c\u534a\u89d2\u300d\u306b\u5909\u63db\u3057\u307e\u3059\u3002\r\n\u00a0\r\n    \t\/\/\u6ce8\u610f\uff01\uff2a\uff41\uff56\uff41\uff33\uff43\uff52\uff49\uff50\uff54\u3067\u3084\u308b\u5834\u5408\u306f\u6700\u5f8c\u306e\uff35\u3092\u3068\u308b\uff01\u3000\uff35\uff34\uff26\uff18\u306e\uff35\u3067\u3059\r\n    \t$RegularExpressionM='\/(^[mM\uff4d\uff2d\u660e])\\D*(0[1-9]|[123][0-9]|4[012345]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?.*$\/u';\/\/\r\n    \t$RegularExpressionT='\/(^[tT\uff54\uff34\u5927])\\D*(0[1-9]|1[012345]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?.*$\/u';\r\n    \t$RegularExpressionS='\/(^[sS\uff53\uff33\u662d])\\D*(0[1-9]|[12345][0-9]|6[01234]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?.*$\/u';\r\n    \t$RegularExpressionH='\/(^[hH\uff48\uff28\u5e73])\\D*(0[1-9]|[12345][0-9]|6[01234]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?.*$\/u';\/\/heisei64\u307e\u3067\r\n    \tif(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionM,$src,$match)){\r\n    \t\t\/\/echo $match[1];\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1868+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n    \t}else if(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionT,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1911+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}else if(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionS,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1925+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]= DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}else if(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionH,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1988+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}\r\n\u00a0\r\n    \t$RegularExpressionS4_2_2='\/^()(19[0-9][0-9]|20[0-9][0-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?.*$\/';\/\/\r\n    \tif(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionS4_2_2,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = $match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}\r\n\u00a0\r\n\u00a0\r\n    \t$RegularExpressionM2_2_2='\/^()(0[1-9]|[123][0-9]|4[012345]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?$\/';\/\/\r\n    \tif(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionM2_2_2,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1868+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}\r\n    \t$RegularExpressionT2_2_2='\/^()(0[1-9]|1[012345]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?$\/';\/\/\r\n    \tif(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionT2_2_2,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1911+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}\r\n    \t$RegularExpressionS2_2_2='\/^()(0[1-9]|[12345][0-9]|6[01234]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?$\/';\/\/\r\n    \tif(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionS2_2_2,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1925+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}\r\n    \t$RegularExpressionH2_2_2='\/^()(0[1-9]|[12345][0-9]|6[01234]|[1-9])\\D*(0[1-9]|1[0-2]|[1-9])?\\D*(0[1-9]|[12][0-9]|3[01]|[1-9])?$\/';\/\/\r\n    \tif(<a href=\"http:\/\/www.php.net\/preg_match\">preg_match<\/a>($RegularExpressionH2_2_2,$src,$match)){\r\n    \t\t$y=null;\r\n    \t\t$m=null;\r\n    \t\t$d=null;\r\n    \t\t$y = 1988+$match[2];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[3]))$m = $match[3];\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($match[4]))$d = $match[4];\r\n    \t\t$outputArray[]=DatetimeUtility::GArraytoString($y,$m,$d);\r\n\u00a0\r\n    \t}\r\n    \treturn $outputArray;\r\n\u00a0\r\n    }\r\n    private static function GArraytoString($y,$m,$d) {\r\n\u00a0\r\n    \tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($m)){\r\n    \t\t$m=<a href=\"http:\/\/www.php.net\/str_pad\">str_pad<\/a>($m, 2, 0, STR_PAD_LEFT); \/\/ 01\r\n    \t\tif(<a href=\"http:\/\/www.php.net\/isset\">isset<\/a>($d)){\r\n    \t\t\t$d=<a href=\"http:\/\/www.php.net\/str_pad\">str_pad<\/a>($d, 2, 0, STR_PAD_LEFT); \/\/ 01\r\n    \t\t\treturn $y.\"-\".$m.\"-\".$d;\r\n    \t\t}\r\n    \t\treturn $y.\"-\".$m;\r\n    \t}\r\n    \treturn $y;\r\n    }<\/pre>\n<p>\u3053\u308c\u3067\u7dba\u9e97\u306bSQL\u3068\u3070\u305b\u308b\u306f\u305a\u3002<\/p>\n<p>\u3088\u304b\u3063\u305f\u3088\u304b\u3063\u305f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; \u548c\u66a6\u306e\u3050\u3061\u3083\u3050\u3061\u3083\u306aString\u304b\u3089SQL\u69d8\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u5909\u63db\u3059\u308b\u3084\u3064\u3067\u307e\u3042\u307e\u3042\u306a\u51fa\u6765\u306a\u306e\u304c\u51fa\u6765\u305f\u3002 \u307b\u3093\u3068\u306fstrftime\u3066\u304d\u306a\u306e\u3067\u3084\u308a\u305f\u304b\u3063\u305f\u3051\u3069Windows\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u306a\u3044\u304b\u3089\u81ea\u4f5c \u6b63\u898f\u8868\u73fe &hellip; <a href=\"https:\/\/medicalfields.jp\/blog\/%e3%83%97%e3%83%ad%e3%82%b0%e3%83%a9%e3%83%9f%e3%83%b3%e3%82%b0\/130\/\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">\u548c\u66a6\u304b\u3089\u897f\u66a6\u3078<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[8,7],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s6kJO0-130","_links":{"self":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/130"}],"collection":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":2,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":132,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions\/132"}],"wp:attachment":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}