SQL Tarih fonksiyonlar\u0131n\u0131n detayl\u0131 listesidir.<\/p>\n
SELECT CURRENT_TIMESTAMP -- Sonu\u00e7 : 2009-07-20 10:39:15.097SELECT DATEADD(day,2,'2009-07-20') -- Sonu\u00e7 : 2009-07-22 00:00:00.000SELECT DATEADD(month,2,'2009-07-20') -- Sonu\u00e7 : 2009-09-20 00:00:00.000SELECT DATEDIFF(day,'2009-07-20','2015-02-09') -- Sonu\u00e7 : 2030 (G\u00fcn olarak ald\u0131k)\r\n\r\nSELECT DATENAME(month, '2009-07-20') -- Sonu\u00e7 : July\r\n\r\nSELECT DATENAME(weekday, '2009-07-20') -- Sonu\u00e7 : Monday\r\n\r\nSELECT DATEPART(month, '2009-07-20') -- Sonu\u00e7 : 7\r\n\r\n--\u015euanki Zaman ve Tarihi verir\r\nSELECT GETDATE() -- Sonu\u00e7 : 2009-07-20 11:52:32.893\r\n\r\n-- Londra - Greenwich Saati\r\nSELECT GETUTCDATE() -- Sonu\u00e7 : 2009-07-20 08:52:44.693\r\n\r\n--Girilen string de\u011ferin tarih olup olmad\u0131\u011f\u0131n\u0131 belirler. 1 ise tarih 0 ise de\u011fil.\r\nSELECT ISDATE('2009-07-20') -- Sonu\u00e7 : 1\r\nSELECT ISDATE('2014-18-09') -- Sonu\u00e7 : 0\r\n\r\n--girilen Tarihin g\u00fcn bilgisini verir.\r\nSELECT DAY('2009-07-20') -- Sonu\u00e7 : 20\r\n--girilen Tarihin ay bilgisini verir.\r\nSELECT MONTH('2009-07-20') -- Sonu\u00e7 : 7\r\n--Girilen Tarihin y\u0131l bilgisini verir.\r\nSELECT YEAR('2009-07-20') -- Sonu\u00e7 : 2009\r\n\r\n--Sistem Zaman\u0131n\u0131 verir.\r\nSELECT SYSDATETIME() -- Sonu\u00e7 : 2009-07-20 11:53:15.7138432\r\n\r\n--Sistem Zaman\u0131n\u0131 Greenwiche g\u00f6re verir.\r\nSELECT SYSUTCDATETIME() -- Sonu\u00e7 : 2009-07-20 08:53:25.9958432\r\n\r\n-- DATEADD: \u015euank, Tarihe 7 G\u00fcn ekleyelim.\r\n-- Bunun i\u00e7in 1 hafta eklemek veya 7 g\u00fcn eklemek yeterlidir.\r\nSELECT DATEADD(DD, 7, GETDATE())\r\nSELECT DATEADD(WW, 1, GETDATE())\r\n\r\n-- \u015euanki Tarihe g\u00f6re Ay\u0131n hangi g\u00fcn\u00fcndeyiz.\r\nSELECT DAY(GETDATE())\r\n\r\n-- \u015euanki Ay\u0131n Ilk g\u00fcn\u00fc\r\nSELECT DATEADD(DD,-(DAY(GETDATE())-1),CONVERT(VARCHAR,GETDATE(),112))\r\n\r\n-- \u015euanki Ay\u0131n son g\u00fcn\u00fc\r\nSELECT DATEADD(DD,-(DAY(DATEADD(MM,1,GETDATE()))),DATEADD(MM,1,\r\nCONVERT(VARCHAR,GETDATE(),112)))\r\n\r\n-- DATEDIFF: Ocak 1 2007 den bugune kadar ka\u00e7 g\u00fcn ge\u00e7ti\r\nSELECT DATEDIFF(DD,'20070101',GETDATE())\r\n\r\n-- DATENAME: \u015euanki Ay\r\nSELECT DATENAME(MM, GETDATE())\r\n\r\n-- Hangi Ayday\u0131z.\r\nSELECT MONTH(GETDATE())\r\n\r\n-- Hangi Y\u0131lday\u0131z\r\nSELECT YEAR(CURRENT_TIMESTAMP)<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
SQL Tarih fonksiyonlar\u0131n\u0131n detayl\u0131 listesidir. SELECT CURRENT_TIMESTAMP — Sonu\u00e7 : 2009-07-20 10:39:15.097SELECT DATEADD(day,2,’2009-07-20′) — Sonu\u00e7 : 2009-07-22 00:00:00.000SELECT DATEADD(month,2,’2009-07-20′) — […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[9,149,15],"class_list":["post-30","post","type-post","status-publish","format-standard","hentry","category-yazilim","tag-mssql","tag-sql","tag-t-sql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"VeYSeL","author_link":"https:\/\/dijitalturk.com\/veysel\/author\/veysel\/"},"uagb_comment_info":0,"uagb_excerpt":"SQL Tarih fonksiyonlar\u0131n\u0131n detayl\u0131 listesidir. SELECT CURRENT_TIMESTAMP -- Sonu\u00e7 : 2009-07-20 10:39:15.097SELECT DATEADD(day,2,'2009-07-20') -- Sonu\u00e7 : 2009-07-22 00:00:00.000SELECT DATEADD(month,2,'2009-07-20') -- […]","_links":{"self":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/comments?post=30"}],"version-history":[{"count":0,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/30\/revisions"}],"wp:attachment":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media?parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/categories?post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/tags?post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}