Datetime2,Datetime and Date Datatype differences . Net Framework, .Net, SQL, Sql Server larger range of values better Accuracy smaller storage space (if optional user-specified precision is specified)
