{"version":"1.0","provider_name":"Database Tutorials","provider_url":"https:\/\/dbtut.com","author_name":"dbtut","author_url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/","title":"DATEDIFF and DATEDIFF_BIG Functions in SQL Server(TSQL) - Database Tutorials","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"gwQr1DbbFe\"><a href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/20\/datediff-and-datediff_big-functions-in-sql-servertsql\/\">DATEDIFF and DATEDIFF_BIG Functions in SQL Server(TSQL)<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/dbtut.com\/index.php\/2019\/02\/20\/datediff-and-datediff_big-functions-in-sql-servertsql\/embed\/#?secret=gwQr1DbbFe\" width=\"600\" height=\"338\" title=\"&#8220;DATEDIFF and DATEDIFF_BIG Functions in SQL Server(TSQL)&#8221; &#8212; Database Tutorials\" data-secret=\"gwQr1DbbFe\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/dbtut.com\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"&nbsp; We can find the difference between the two dates using the following dateparts with the DATEDIFF function. The return data type is int. If the int data type is insufficient for the difference between two dates, you should use the DATEDIFF_BIG function. You can use it in the same way as DATEDIFF function. Only &hellip;","thumbnail_url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6bb0a9a8967.png"}