{"id":651,"date":"2015-01-15T10:02:53","date_gmt":"2015-01-15T08:02:53","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=651"},"modified":"2015-10-16T17:40:08","modified_gmt":"2015-10-16T14:40:08","slug":"sqlinfo-sonucu-donen-metini-tarih-formatina-cevirmek","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sqlinfo-sonucu-donen-metini-tarih-formatina-cevirmek\/","title":{"rendered":"SQLINFO SONUCU D\u00d6NEN MET\u0130N\u0130 TAR\u0130H FORMATINA \u00c7EV\u0130RMEK"},"content":{"rendered":"<p>\u0130ki \u015fekilde SQLINFO ile gelen metin alan\u0131n\u0131 tarihe \u00e7evirebilirsiniz.<\/p>\n<p>B\u0130R\u0130NC\u0130 SE\u00c7ENEK;<\/p>\n<p>G\u00dcN:<br \/>\nVAL(SUBSTR([Tan\u0131ml\u0131 alan],1,2))<\/p>\n<p>AY:<br \/>\nVAL(SUBSTR([Tan\u0131ml\u0131 alan],4,2))<\/p>\n<p>YIL:<br \/>\nVAL(SUBSTR([Tan\u0131ml\u0131 alan],7,4))<\/p>\n<p>TAR\u0130H:<br \/>\nDATE([G\u00dcN],[AY],[YIL])<\/p>\n<p>\u0130K\u0130NC\u0130 SE\u00c7ENEK;<\/p>\n<p>DATE(VAL(SUBSTR([Tan\u0131ml\u0131 alan],1,2)),VAL(SUBSTR([Tan\u0131ml\u0131 alan],4,2)),VAL(SUBSTR([Tan\u0131ml\u0131 alan],7,4)))<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130ki \u015fekilde SQLINFO ile gelen metin alan\u0131n\u0131 tarihe \u00e7evirebilirsiniz. B\u0130R\u0130NC\u0130 SE\u00c7ENEK; G\u00dcN: VAL(SUBSTR([Tan\u0131ml\u0131 alan],1,2)) AY: VAL(SUBSTR([Tan\u0131ml\u0131 alan],4,2)) YIL: VAL(SUBSTR([Tan\u0131ml\u0131 alan],7,4)) TAR\u0130H: DATE([G\u00dcN],[AY],[YIL]) \u0130K\u0130NC\u0130 SE\u00c7ENEK; DATE(VAL(SUBSTR([Tan\u0131ml\u0131 alan],1,2)),VAL(SUBSTR([Tan\u0131ml\u0131 alan],4,2)),VAL(SUBSTR([Tan\u0131ml\u0131 alan],7,4)))<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-651","post","type-post","status-publish","format-standard","hentry","category-logorapor"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=651"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/651\/revisions"}],"predecessor-version":[{"id":652,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/651\/revisions\/652"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}