Guest

Dotnet DateTime to SqlDateTime interval

By: a guest on Dec 9th, 2011  |  syntax: C#  |  size: 1.18 KB  |  hits: 62  |  expires: Never
download  |  raw  |  embed  |  report abuse
Copied
  1. public static class DateTimeExtensions
  2.     {
  3.         /// <summary>This method returns the datetime fitting into min/max of Sqlserver
  4.         /// as per http://codebetter.com/petervanooijen/2008/08/21/valid-date-time-values-in-sql-server-sqldatetime-vs-datetime/
  5.         /// More info can be found at http://www.selfelected.com/convert-dotnet-datetime-to-sqlserver-sqldatetime/
  6.         /// </summary>
  7.         /// <param name="dt"></param>
  8.         /// <returns></returns>
  9.         public static DateTime ToValidSqlserverDatetime(this DateTime dt)
  10.         {
  11.             //  Must cast System.Data.SqlTypes.SqlDateTime.MinValue: http://codebetter.com/petervanooijen/2008/08/21/valid-date-time-values-in-sql-server-sqldatetime-vs-datetime/
  12.             if (dt < (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue)
  13.             {
  14.                 return (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
  15.             }
  16.             else if (dt > (DateTime)System.Data.SqlTypes.SqlDateTime.MaxValue)
  17.             {
  18.                 return (DateTime)System.Data.SqlTypes.SqlDateTime.MaxValue;
  19.             }
  20.             else
  21.             {
  22.                 return dt;
  23.             }
  24.         }
  25.     }
  26.