SQL Server Useful Code

Difference between datepart using DATEDIFF


SELECT DATEDIFF(year, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(quarter, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(month, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(dayofyear, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(day, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(week, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(hour, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(minute, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(second, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000');
SELECT DATEDIFF(millisecond, '2011-12-31 22:59:59.9999999' , '2012-01-01 00:00:00.0000000'

Comments

Post a Comment

Popular posts from this blog

C# code to Check IE Proxy Settings

private static void CheckIEProxySettings() {     string strFileURL = " http://programmersvision.blogspot.in ";     HttpWebRequest WebReqt = (HttpWebRequest)HttpWebRequest.Create(strFileURL);     WebProxy WP = new WebProxy(WebReqt.Proxy.GetProxy(new Uri(strFileURL)));     WP.Credentials = CredentialCache.DefaultCredentials;     Console.WriteLine(WP.Address);     // or use this method     //CheckForProxy(new Uri(" http://http://programmersvision.blogspot.in ")); } private static void CheckForProxy(Uri resource) {     WebProxy proxy = (WebProxy)WebProxy.GetDefaultProxy();     Uri proxyUri = proxy.GetProxy(resource);     if (proxyUri == resource)     {         Console.WriteLine("There is no proxy for {0}", resource);     }     else     { ...
Read more

Convert XElement to DataTable

public DataTable XElementToDataTable(XElement x)  {    DataTable dt = new DataTable();   XElement setup = (from p in x.Descendants() select p).First();    foreach (XElement xe in setup.Descendants()) // build your DataTable      dt.Columns.Add(new DataColumn(xe.Name.ToString(),typeof(string))); // add columns to your dt   var all = from p in x.Descendants(setup.Name.ToString()) select p;    foreach (XElement xe in all)    {      DataRow dr = dt.NewRow();      foreach (XElement xe2 in xe.Descendants())        dr[xe2.Name.ToString()] = xe2.Value; //add in the values      dt.Rows.Add(dr);    }    return dt;  }
Read more