{"id":174,"date":"2015-12-09T10:59:31","date_gmt":"2015-12-09T01:59:31","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=174"},"modified":"2015-12-09T10:59:31","modified_gmt":"2015-12-09T01:59:31","slug":"date-related-sql-query","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2015\/12\/09\/date-related-sql-query\/","title":{"rendered":"\ub0a0\uc9dc \uad00\ub828 SQL Query"},"content":{"rendered":"

\u200b<\/a><\/p>\n

—-Today<\/div>\n
SELECT GETDATE() ‘Today’<\/div>\n
—-Yesterday<\/div>\n
SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’<\/div>\n
<\/div>\n
–Start of Current Day<\/div>\n
SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) ‘Start of Current Day’<\/div>\n
–End of Current day<\/div>\n
SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),1)) ‘End of Current day’<\/div>\n
<\/div>\n
–Start of Yesterday<\/div>\n
SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-1) ‘Start of Yesterday’<\/div>\n
–End of Yesterday<\/div>\n
SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)) ‘End of Yesterday’<\/div>\n
<\/div>\n
–First day of week by ISO<\/div>\n
SELECT DATEADD(dd,7*(DATEDIFF(dd,’1973-01-01′,’2015-01-04′)\/7),’1973-01-01′) ‘First day of ISO Week’<\/div>\n
<\/div>\n
—-First Day of Current Week<\/div>\n
SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘First Day of Current Week’<\/div>\n
—-Last Day of Current Week<\/div>\n
SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘Last Day of Current Week’<\/div>\n
—-First Day of Last Week<\/div>\n
SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) ‘First Day of Last Week’<\/div>\n
—-Last Day of Last Week<\/div>\n
SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) ‘Last Day of Last Week’<\/div>\n
—-First Day of Current Month<\/div>\n
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) ‘First Day of Current Month’<\/div>\n
—-Last Day of Current Month<\/div>\n
SELECT DATEADD(ms,- 3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))) ‘Last Day of Current Month’<\/div>\n
—-First Day of Last Month<\/div>\n
SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)) ‘First Day of Last Month’<\/div>\n
—-Last Day of Last Month<\/div>\n
SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))) ‘Last Day of Last Month’<\/div>\n
—-First Day of Current Quarter<\/div>\n
SELECT DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0) ‘First Day of Current Quarter’<\/div>\n
—-First Day of Current Year<\/div>\n
SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0) ‘First Day of Current Year’<\/div>\n
—-Last Day of Current Year<\/div>\n
SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0))) ‘Last Day of Current Year’<\/div>\n
—-First Day of Last Year<\/div>\n
SELECT DATEADD(yy,-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)) ‘First Day of Last Year’<\/div>\n
—-Last Day of Last Year<\/div>\n
SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))) ‘Last Day of Last Year’ <font color=”#111111″ face=”Segoe UI, Arial, sans-serif”><span style=”font-size: 14px; white-space: normal;”><\/div>\n
<\/span><\/font><\/div>\n","protected":false},"excerpt":{"rendered":"

\u200b —-Today SELECT GETDATE() ‘Today’ —-Yesterday SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’ –Start of Current Day SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) ‘Start of Current Day’ –End of Current day SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),1)) ‘End of Current day’ –Start of Yesterday SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-1) ‘Start of Yesterday’ –End of Yesterday SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)) ‘End of Yesterday’ –First day of week by ISO SELECT DATEADD(dd,7*(DATEDIFF(dd,’1973-01-01′,’2015-01-04′)\/7),’1973-01-01′) ‘First day […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-174","post","type-post","status-publish","format-standard","hentry","category-about-linux"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=174"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/174\/revisions"}],"predecessor-version":[{"id":175,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/174\/revisions\/175"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}