{"id":490,"date":"2022-09-17T06:00:00","date_gmt":"2022-09-17T06:00:00","guid":{"rendered":"https:\/\/datablog.roman-halliday.com\/?p=490"},"modified":"2022-09-16T16:44:25","modified_gmt":"2022-09-16T16:44:25","slug":"dates-in-sql-server","status":"publish","type":"post","link":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/","title":{"rendered":"Dates In SQL Server"},"content":{"rendered":"\n<p>Some time ago what started as one article on dates and their value, turned into a mini-series (nearly as engaging as The Queens Gambit). I kept finding more to say about dates and examples to give. I&#8217;m now pulling them together with a little narrative. &#8220;One page to rule them all&#8221; as it were.<\/p>\n\n\n\n<div class=\"wp-block-cover is-light\"><span aria-hidden=\"true\" class=\"wp-block-cover__background has-background-dim\"><\/span><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"1200\" class=\"wp-block-cover__image-background wp-image-510\" alt=\"White Calendar\" src=\"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/273153.jpg\" data-object-fit=\"cover\" srcset=\"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/273153.jpg 1600w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/273153-300x225.jpg 300w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/273153-1024x768.jpg 1024w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/273153-768x576.jpg 768w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/273153-1536x1152.jpg 1536w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/273153-360x270.jpg 360w\" sizes=\"auto, (max-width: 1600px) 100vw, 1600px\" \/><div class=\"wp-block-cover__inner-container is-layout-flow wp-block-cover-is-layout-flow\">\n<p class=\"has-text-align-center has-white-color has-text-color has-x-large-font-size\">What&#8217;s so significant about dates?<\/p>\n\n\n\n<p class=\"has-text-align-center has-white-color has-text-color has-x-large-font-size\">We know they are valuable!<\/p>\n<\/div><\/div>\n\n\n\n<p>We all know that dates themselves are important, but what sometimes gets overlooked is the date datatype (and other date and time datatypes). When and how to use it, and how it can be leveraged.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Getting started<\/h2>\n\n\n\n<p>A good introduction, or at least a refresher on date-related datatypes.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/05\/01\/dates-in-sql-server-managing-manipulating-dates\/\">Dates In SQL Server: Managing &amp; Manipulating Dates<\/a> &#8211; Data types, usage and formatting for display.<\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/05\/15\/dates-in-sql-server-datetime2-vs-smalldatetime\/\">Dates In SQL Server: DATETIME2 vs SMALLDATETIME<\/a> &#8211; A dive into two common (but different) datatypes used for storing date with time. For people new to looking into datatypes, it is a great demonstration of the subtle, yet significant difference between similar-looking data types.<\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/06\/16\/dates-in-sql-server-adding-subtracting\/\">Dates In SQL Server: Adding &amp; subtracting<\/a> &#8211; Simple manipulation, but a real demonstration of the value of using the correct data type.<\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/06\/30\/dates-in-sql-server-ambiguous-date-specification\/\">Dates In SQL Server: Ambiguous date specification<\/a> &#8211; Some of the dangers and pitfalls to be conscious of when working with dates.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Getting warmed up<\/h2>\n\n\n\n<p>Useful reading which the later articles build on (or reuse).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/06\/01\/dates-in-sql-server-create-sample-date-ranges\/\">Dates In SQL Server: Create Sample Date Ranges<\/a> &#8211; Examples of ways to create a table of consecutive dates.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Steaming ahead<\/h2>\n\n\n\n<p>Specialised usage examples working with dates.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Iteration (looping over)<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/06\/09\/dates-in-sql-server-iteration-of-date-ranges\/\">Dates In SQL Server: Iteration of Date Ranges<\/a> &#8211; Loop over a series of dates (logic can be changed to loop over anything, but dates are the most common in data warehousing).<\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2019\/11\/30\/dates-in-sql-server-creating-date-range-batches\/\">Dates In SQL Server: Creating Date Range Batches<\/a> &#8211; This is a more complicated example and quite niche, after creating a solution using the approach I thought it was a great example to write about.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Categorisation &amp; Identigication<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/06\/23\/dates-in-sql-server-weekdays-weekends\/\">Dates In SQL Server: Weekdays &amp; Weekends<\/a> &#8211; Identifying repeated days which often impact processing or business peaks and troughs.<\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/07\/14\/dates-in-sql-server-public-holidays\/\">Dates In SQL Server: Public Holidays<\/a> &#8211; Identifying and managing information about holidays, the more you think about it the more complicated it can become.<\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/07\/07\/dates-in-sql-server-the-last-x-of-the-month\/\">Dates In SQL Server: The last X of the month<\/a> &#8211; This is a niche example, of how to identify specific days in a month (usually to identify business process points).<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Partitions using Dates<\/h2>\n\n\n\n<p>A common theme in data warehousing is partitioning, either for disk usage or performance improvements. Often, the nature of data and time dates make ideal candidates for partitioning fact tables:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2019\/03\/31\/partitions-in-sql-server-creating-a-partitioned-fact-table-by-date\/\">Partitions in SQL Server: Creating a Partitioned Fact Table (by date)<\/a><\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2019\/04\/14\/partitions-in-sql-server-partition-an-existing-fact-table-by-date\/\">Partitions in SQL Server: Partition an Existing Fact Table (by date)<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Dates in other databases<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1280\" height=\"768\" src=\"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/3396348.jpg\" alt=\"\" class=\"wp-image-512\" srcset=\"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/3396348.jpg 1280w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/3396348-300x180.jpg 300w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/3396348-1024x614.jpg 1024w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/3396348-768x461.jpg 768w, https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/3396348-450x270.jpg 450w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/figure>\n\n\n\n<p>Although this page is about SQL Server, I&#8217;ve written equivalent notes on other databases:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2019\/10\/19\/dates-in-hive\/\">Dates In Hive<\/a><\/li><li><a href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2018\/07\/21\/__trashed\/\">Dates In Oracle: Ranges, Manipulation &amp; Loops<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Some time ago what started as one article on dates and their value, turned into a mini-series (nearly as engaging as The Queens Gambit). I kept finding more to say about dates and examples to give. I&#8217;m now pulling them together with a little narrative.<\/p>\n","protected":false},"author":1,"featured_media":515,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[52,12,7,8],"class_list":["post-490","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-sql-server","tag-database","tag-date","tag-sql","tag-t-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Dates In SQL Server - Rows Across The Lake<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dates In SQL Server - Rows Across The Lake\" \/>\n<meta property=\"og:description\" content=\"Some time ago what started as one article on dates and their value, turned into a mini-series (nearly as engaging as The Queens Gambit). I kept finding more to say about dates and examples to give. I&#039;m now pulling them together with a little narrative.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Rows Across The Lake\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-17T06:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/577585.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"david\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@d_roman_h\" \/>\n<meta name=\"twitter:site\" content=\"@d_roman_h\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"david\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/\"},\"author\":{\"name\":\"david\",\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/#\\\/schema\\\/person\\\/575f96d2590c3085923ff9e1b565748b\"},\"headline\":\"Dates In SQL Server\",\"datePublished\":\"2022-09-17T06:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/\"},\"wordCount\":496,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/#\\\/schema\\\/person\\\/575f96d2590c3085923ff9e1b565748b\"},\"image\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/577585.jpg\",\"keywords\":[\"database\",\"date\",\"SQL\",\"T-SQL\"],\"articleSection\":[\"Databases\",\"SQL Server\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/\",\"url\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/\",\"name\":\"Dates In SQL Server - Rows Across The Lake\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/577585.jpg\",\"datePublished\":\"2022-09-17T06:00:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/577585.jpg\",\"contentUrl\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/577585.jpg\",\"width\":1600,\"height\":1200,\"caption\":\"Data Codes through Eyeglasses\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/index.php\\\/2022\\\/09\\\/17\\\/dates-in-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dates In SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/#website\",\"url\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/\",\"name\":\"Rows Across The Lake\",\"description\":\"Data &amp; Databases\",\"publisher\":{\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/#\\\/schema\\\/person\\\/575f96d2590c3085923ff9e1b565748b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/datablog.roman-halliday.com\\\/#\\\/schema\\\/person\\\/575f96d2590c3085923ff9e1b565748b\",\"name\":\"david\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g\",\"caption\":\"david\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dates In SQL Server - Rows Across The Lake","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/","og_locale":"en_GB","og_type":"article","og_title":"Dates In SQL Server - Rows Across The Lake","og_description":"Some time ago what started as one article on dates and their value, turned into a mini-series (nearly as engaging as The Queens Gambit). I kept finding more to say about dates and examples to give. I'm now pulling them together with a little narrative.","og_url":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/","og_site_name":"Rows Across The Lake","article_published_time":"2022-09-17T06:00:00+00:00","og_image":[{"width":1600,"height":1200,"url":"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/577585.jpg","type":"image\/jpeg"}],"author":"david","twitter_card":"summary_large_image","twitter_creator":"@d_roman_h","twitter_site":"@d_roman_h","twitter_misc":{"Written by":"david","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/"},"author":{"name":"david","@id":"https:\/\/datablog.roman-halliday.com\/#\/schema\/person\/575f96d2590c3085923ff9e1b565748b"},"headline":"Dates In SQL Server","datePublished":"2022-09-17T06:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/"},"wordCount":496,"commentCount":0,"publisher":{"@id":"https:\/\/datablog.roman-halliday.com\/#\/schema\/person\/575f96d2590c3085923ff9e1b565748b"},"image":{"@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/577585.jpg","keywords":["database","date","SQL","T-SQL"],"articleSection":["Databases","SQL Server"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/","url":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/","name":"Dates In SQL Server - Rows Across The Lake","isPartOf":{"@id":"https:\/\/datablog.roman-halliday.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/577585.jpg","datePublished":"2022-09-17T06:00:00+00:00","breadcrumb":{"@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#primaryimage","url":"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/577585.jpg","contentUrl":"https:\/\/datablog.roman-halliday.com\/wp-content\/uploads\/2022\/09\/577585.jpg","width":1600,"height":1200,"caption":"Data Codes through Eyeglasses"},{"@type":"BreadcrumbList","@id":"https:\/\/datablog.roman-halliday.com\/index.php\/2022\/09\/17\/dates-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/datablog.roman-halliday.com\/"},{"@type":"ListItem","position":2,"name":"Dates In SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/datablog.roman-halliday.com\/#website","url":"https:\/\/datablog.roman-halliday.com\/","name":"Rows Across The Lake","description":"Data &amp; Databases","publisher":{"@id":"https:\/\/datablog.roman-halliday.com\/#\/schema\/person\/575f96d2590c3085923ff9e1b565748b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datablog.roman-halliday.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/datablog.roman-halliday.com\/#\/schema\/person\/575f96d2590c3085923ff9e1b565748b","name":"david","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g","caption":"david"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/acddbc676a1d5c73795edcf0627ee39e5aa947da9033b58373e03d93122cb3b7?s=96&d=mm&r=g"}}]}},"_links":{"self":[{"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/posts\/490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/comments?post=490"}],"version-history":[{"count":5,"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/posts\/490\/revisions"}],"predecessor-version":[{"id":519,"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/posts\/490\/revisions\/519"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/media\/515"}],"wp:attachment":[{"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/media?parent=490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/categories?post=490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datablog.roman-halliday.com\/index.php\/wp-json\/wp\/v2\/tags?post=490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}