{"id":653,"date":"2015-01-15T10:03:51","date_gmt":"2015-01-15T08:03:51","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=653"},"modified":"2015-10-16T17:39:59","modified_gmt":"2015-10-16T14:39:59","slug":"substr-fonksiyonu-ile-tarih-ayraclarinin-kaldirilmasi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/substr-fonksiyonu-ile-tarih-ayraclarinin-kaldirilmasi\/","title":{"rendered":"SUBSTR FONKS\u0130YONU \u0130LE TAR\u0130H AYRA\u00c7LARININ KALDIRILMASI"},"content":{"rendered":"<p>Tarih format alan\u0131 ile DATESTR fonksiyonu ile tarhii metin format\u0131nda vermektedir. Daha sonra metin format\u0131na \u00e7evirilen alan Tarih b\u00fct\u00fcn alan\u0131nda SUSSTR fonksiyonu ile i\u00e7erisindeki karakterler \u00e7ekilmektedir, dolay\u0131s\u0131 ile tatih format tan\u0131ml\u0131 alan\u0131 ile gelen alan\u0131 kontrol edin hangi karakterlerini \u00e7ekmek istiyor iseniz sol&#8217;dan sa\u011fa do\u011fru numaras\u0131n\u0131 (SUBSTR([TAR\u0130H FORMAT],1,2)) ve (SUBSTR([TAR\u0130H FORMAT],1,2)) ka\u00e7 karakter \u00e7ekmek istedi\u011finizi belitirsiniz. Bu \u00e7ek<br \/>\nlen karakterlerde aralar\u0131na &#8216;+&#8217; kolayark birle\u015ftirilir.<\/p>\n<p>Kontrollerinizi bu \u015fekilde yap\u0131n\u0131z.<\/p>\n<p>Tarih alan\u0131n\u0131z\u0131 bir tan\u0131ml\u0131 alanda DATESTR i\u00e7erisine ekleyin<\/p>\n<p>\u0130sim: TAR\u0130H FORMAT<br \/>\nT\u00fcr: Metin<br \/>\nDATESTR([Tarihi],5)<\/p>\n<p>Daha sonra bu a\u015fa\u011f\u0131daki k\u0131rm\u0131z\u0131 alanlara kendi tan\u0131ml\u0131 alan\u0131n\u0131z\u0131 ekleyerek yeni bir tan\u0131ml\u0131 alan kullan\u0131n olacakt\u0131r.<\/p>\n<p>\u0130sim : TAR\u0130H B\u00dcT\u00dcN<br \/>\nT\u00fcr: Metin<br \/>\nSUBSTR([TAR\u0130H FORMAT],1,2)+SUBSTR([TAR\u0130H FORMAT],4,2)+SUBSTR( [TAR\u0130H FORMAT],7,4)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tarih format alan\u0131 ile DATESTR fonksiyonu ile tarhii metin format\u0131nda vermektedir. Daha sonra metin format\u0131na \u00e7evirilen alan Tarih b\u00fct\u00fcn alan\u0131nda SUSSTR fonksiyonu ile i\u00e7erisindeki karakterler \u00e7ekilmektedir, dolay\u0131s\u0131 ile tatih format tan\u0131ml\u0131 alan\u0131 ile gelen alan\u0131 kontrol edin hangi karakterlerini \u00e7ekmek istiyor iseniz sol&#8217;dan sa\u011fa do\u011fru numaras\u0131n\u0131 (SUBSTR([TAR\u0130H FORMAT],1,2)) ve (SUBSTR([TAR\u0130H FORMAT],1,2)) ka\u00e7 karakter \u00e7ekmek istedi\u011finizi [&hellip;]<\/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-653","post","type-post","status-publish","format-standard","hentry","category-logorapor"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/653","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=653"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/653\/revisions"}],"predecessor-version":[{"id":654,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/653\/revisions\/654"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}