Mysql en s\u0131k kulland\u0131\u011f\u0131m\u0131z komutlar genellikle tarih ve saat komutlar\u0131d\u0131r. Biraz karmas\u0131k gibi g\u00f6r\u00fcnsede basittir asl\u0131nda komutlar.<\/p>\n
select now();<\/strong> \/*\u015fuan ki tarih ve saati verir*\/<\/p>\n <\/p>\n select curdate();<\/strong> \/* ge\u00e7erli tarihi verir *\/<\/p>\n select curtime();<\/strong> \/* ge\u00e7erli saati verir *\/<\/p>\n SELECT DATE(‘2003-12-30 01:02:03’);<\/strong> \/*bu sat\u0131rda sade tarih bilgisini verir*\/<\/p>\n select date(now());<\/strong>\/*\u015fuanki tarihi verir*\/<\/p>\n select dayname(‘1985-09-05’);<\/strong>\/* belirtilen tarihtedeki g\u00fcn ismini verir “Thursday”*\/<\/p>\n set lc_time_names=’tr_TR’;<\/strong> \/*saat ayarlar\u0131n\u0131 turkiye g\u00f6re ayarlar*\/<\/p>\n select dayname(date(now()));<\/strong> \/*bu g\u00fcn\u00fcn ismini verir “pazar”*\/<\/p>\n select monthname(date(now()));<\/strong> \/*bu ay\u0131n ismini verir*\/<\/p>\n select month(now());<\/strong> \/*bu ay\u0131n rakam\u0131n\u0131 verir nisan 4 gibi*\/<\/p>\n select datediff(‘2017-04-02′,’2017-01-01’);<\/strong> \/*iki tarih aras\u0131ndaki fark\u0131 verir “91”*\/<\/p>\n select date_format(‘2017-04-02′,’%W,%M,%Y’);<\/strong> \/* belirtilen tarihi formata g\u00f6re verir Pazar,Nisan,2017*\/<\/p>\n","protected":false},"excerpt":{"rendered":" Mysql en s\u0131k kulland\u0131\u011f\u0131m\u0131z komutlar genellikle tarih ve saat komutlar\u0131d\u0131r. Biraz karmas\u0131k gibi g\u00f6r\u00fcnsede basittir asl\u0131nda komutlar. select now(); \/*\u015fuan ki tarih ve saati verir*\/ select curdate(); \/* ge\u00e7erli tarihi verir *\/ select curtime(); \/* ge\u00e7erli saati verir *\/ SELECT DATE(‘2003-12-30 01:02:03’); \/*bu sat\u0131rda sade tarih bilgisini verir*\/ select date(now());\/*\u015fuanki tarihi verir*\/ select dayname(‘1985-09-05’);\/* […]<\/p>\n","protected":false},"author":1,"featured_media":2258,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,20],"tags":[273,277,279,284,286,287],"class_list":["post-2143","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel","category-mysql","tag-mysql","tag-mysql-date","tag-mysql-de-tarih-ve-saat-islemleri","tag-mysql-komut","tag-mysql-tarih-ve-saat-komutlari","tag-mysql-time"],"_links":{"self":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2143"}],"version-history":[{"count":1,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2143\/revisions"}],"predecessor-version":[{"id":2285,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2143\/revisions\/2285"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/media\/2258"}],"wp:attachment":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}